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 t0.id AS ID_1, t0.title AS TITLE_2, t0.description AS DESCRIPTION_3, t0.created_at AS CREATED_AT_4, t0.category_id AS CATEGORY_ID_5, t0.creator_id AS CREATOR_ID_6 FROM questions t0 WHERE t0.id = ?

[
  21
]

SELECT
  t0.id AS ID_1,
  t0.title AS TITLE_2,
  t0.description AS DESCRIPTION_3,
  t0.created_at AS CREATED_AT_4,
  t0.category_id AS CATEGORY_ID_5,
  t0.creator_id AS CREATOR_ID_6
FROM
  questions t0
WHERE
  t0.id = ?

SELECT t0.id AS ID_1, t0.title AS TITLE_2, t0.description AS DESCRIPTION_3, t0.created_at AS CREATED_AT_4, t0.category_id AS CATEGORY_ID_5, t0.creator_id AS CREATOR_ID_6 FROM questions t0 WHERE t0.id = 21;

SELECT a.* FROM (SELECT a0_.id AS ID_0, a0_.description AS DESCRIPTION_1, a0_.created_at AS CREATED_AT_2, q1_.id AS ID_3, q1_.title AS TITLE_4, q1_.description AS DESCRIPTION_5, q1_.created_at AS CREATED_AT_6, a2_.id AS ID_7, a2_.description AS DESCRIPTION_8, a2_.created_at AS CREATED_AT_9, u3_.id AS ID_10, u3_.username AS USERNAME_11, u3_.userscu AS USERSCU_12, u3_.created_at AS CREATED_AT_13, u3_.updated_at AS UPDATED_AT_14, u3_.deleted AS DELETED_15, a0_.question_id AS QUESTION_ID_16, a0_.parent_answer_id AS PARENT_ANSWER_ID_17, a0_.creator_id AS CREATOR_ID_18, q1_.category_id AS CATEGORY_ID_19, q1_.creator_id AS CREATOR_ID_20, a2_.question_id AS QUESTION_ID_21, a2_.parent_answer_id AS PARENT_ANSWER_ID_22, a2_.creator_id AS CREATOR_ID_23, u3_.role_id AS ROLE_ID_24 FROM answers a0_ LEFT JOIN questions q1_ ON a0_.question_id = q1_.id LEFT JOIN answers a2_ ON a0_.parent_answer_id = a2_.id LEFT JOIN users u3_ ON a0_.creator_id = u3_.id WHERE q1_.id = ? ORDER BY a0_.id ASC) a WHERE ROWNUM <= 20

[
  21
]

SELECT
  a.*
FROM
  (
    SELECT
      a0_.id AS ID_0,
      a0_.description AS DESCRIPTION_1,
      a0_.created_at AS CREATED_AT_2,
      q1_.id AS ID_3,
      q1_.title AS TITLE_4,
      q1_.description AS DESCRIPTION_5,
      q1_.created_at AS CREATED_AT_6,
      a2_.id AS ID_7,
      a2_.description AS DESCRIPTION_8,
      a2_.created_at AS CREATED_AT_9,
      u3_.id AS ID_10,
      u3_.username AS USERNAME_11,
      u3_.userscu AS USERSCU_12,
      u3_.created_at AS CREATED_AT_13,
      u3_.updated_at AS UPDATED_AT_14,
      u3_.deleted AS DELETED_15,
      a0_.question_id AS QUESTION_ID_16,
      a0_.parent_answer_id AS PARENT_ANSWER_ID_17,
      a0_.creator_id AS CREATOR_ID_18,
      q1_.category_id AS CATEGORY_ID_19,
      q1_.creator_id AS CREATOR_ID_20,
      a2_.question_id AS QUESTION_ID_21,
      a2_.parent_answer_id AS PARENT_ANSWER_ID_22,
      a2_.creator_id AS CREATOR_ID_23,
      u3_.role_id AS ROLE_ID_24
    FROM
      answers a0_
      LEFT JOIN questions q1_ ON a0_.question_id = q1_.id
      LEFT JOIN answers a2_ ON a0_.parent_answer_id = a2_.id
      LEFT JOIN users u3_ ON a0_.creator_id = u3_.id
    WHERE
      q1_.id = ?
    ORDER BY
      a0_.id ASC
  ) a
WHERE
  ROWNUM <= 20

SELECT a.* FROM (SELECT a0_.id AS ID_0, a0_.description AS DESCRIPTION_1, a0_.created_at AS CREATED_AT_2, q1_.id AS ID_3, q1_.title AS TITLE_4, q1_.description AS DESCRIPTION_5, q1_.created_at AS CREATED_AT_6, a2_.id AS ID_7, a2_.description AS DESCRIPTION_8, a2_.created_at AS CREATED_AT_9, u3_.id AS ID_10, u3_.username AS USERNAME_11, u3_.userscu AS USERSCU_12, u3_.created_at AS CREATED_AT_13, u3_.updated_at AS UPDATED_AT_14, u3_.deleted AS DELETED_15, a0_.question_id AS QUESTION_ID_16, a0_.parent_answer_id AS PARENT_ANSWER_ID_17, a0_.creator_id AS CREATOR_ID_18, q1_.category_id AS CATEGORY_ID_19, q1_.creator_id AS CREATOR_ID_20, a2_.question_id AS QUESTION_ID_21, a2_.parent_answer_id AS PARENT_ANSWER_ID_22, a2_.creator_id AS CREATOR_ID_23, u3_.role_id AS ROLE_ID_24 FROM answers a0_ LEFT JOIN questions q1_ ON a0_.question_id = q1_.id LEFT JOIN answers a2_ ON a0_.parent_answer_id = a2_.id LEFT JOIN users u3_ ON a0_.creator_id = u3_.id WHERE q1_.id = 21 ORDER BY a0_.id ASC) a WHERE ROWNUM <= 20;

SELECT COUNT(a0_.id) AS SCLR_0 FROM answers a0_

[]

SELECT
  COUNT(a0_.id) AS SCLR_0
FROM
  answers a0_

SELECT COUNT(a0_.id) AS SCLR_0 FROM answers a0_;

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.description AS DESCRIPTION_3, t0.created_at AS CREATED_AT_4, t0.updated_at AS UPDATED_AT_5, t0.visible AS VISIBLE_6, t0.order_categories AS ORDER_CATEGORIES_7, t0.parent_categorie_id AS PARENT_CATEGORIE_ID_8 FROM categories t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS ID_1,
  t0.name AS NAME_2,
  t0.description AS DESCRIPTION_3,
  t0.created_at AS CREATED_AT_4,
  t0.updated_at AS UPDATED_AT_5,
  t0.visible AS VISIBLE_6,
  t0.order_categories AS ORDER_CATEGORIES_7,
  t0.parent_categorie_id AS PARENT_CATEGORIE_ID_8
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.description AS DESCRIPTION_3, t0.created_at AS CREATED_AT_4, t0.updated_at AS UPDATED_AT_5, t0.visible AS VISIBLE_6, t0.order_categories AS ORDER_CATEGORIES_7, t0.parent_categorie_id AS PARENT_CATEGORIE_ID_8 FROM categories t0 WHERE t0.id = 3;