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 c0_.id AS ID_0, c0_.name AS NAME_1, c0_.description AS DESCRIPTION_2, c0_.created_at AS CREATED_AT_3, c0_.updated_at AS UPDATED_AT_4, c0_.visible AS VISIBLE_5, c0_.order_categories AS ORDER_CATEGORIES_6, c0_.parent_categorie_id AS PARENT_CATEGORIE_ID_7 FROM categories c0_ WHERE c0_.visible = ? ORDER BY c0_.id ASC) a WHERE ROWNUM <= 20

[
  1
]

SELECT
  a.*
FROM
  (
    SELECT
      c0_.id AS ID_0,
      c0_.name AS NAME_1,
      c0_.description AS DESCRIPTION_2,
      c0_.created_at AS CREATED_AT_3,
      c0_.updated_at AS UPDATED_AT_4,
      c0_.visible AS VISIBLE_5,
      c0_.order_categories AS ORDER_CATEGORIES_6,
      c0_.parent_categorie_id AS PARENT_CATEGORIE_ID_7
    FROM
      categories c0_
    WHERE
      c0_.visible = ?
    ORDER BY
      c0_.id ASC
  ) a
WHERE
  ROWNUM <= 20

SELECT a.* FROM (SELECT c0_.id AS ID_0, c0_.name AS NAME_1, c0_.description AS DESCRIPTION_2, c0_.created_at AS CREATED_AT_3, c0_.updated_at AS UPDATED_AT_4, c0_.visible AS VISIBLE_5, c0_.order_categories AS ORDER_CATEGORIES_6, c0_.parent_categorie_id AS PARENT_CATEGORIE_ID_7 FROM categories c0_ WHERE c0_.visible = 1 ORDER BY c0_.id ASC) a WHERE ROWNUM <= 20;

SELECT COUNT(c0_.id) AS SCLR_0 FROM categories c0_ WHERE c0_.visible = ?

[
  1
]

SELECT
  COUNT(c0_.id) AS SCLR_0
FROM
  categories c0_
WHERE
  c0_.visible = ?

SELECT COUNT(c0_.id) AS SCLR_0 FROM categories c0_ WHERE c0_.visible = 1;