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 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 = ? AND c0_.parent_categorie_id = ? ORDER BY c0_.id ASC

[
  1
  4
]

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 = ?
  AND c0_.parent_categorie_id = ?
ORDER BY
  c0_.id ASC

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 AND c0_.parent_categorie_id = 4 ORDER BY c0_.id ASC;

SELECT c0_.id AS ID_0 FROM categories c0_ WHERE c0_.parent_categorie_id = ?

[
  4
]

SELECT
  c0_.id AS ID_0
FROM
  categories c0_
WHERE
  c0_.parent_categorie_id = ?

SELECT c0_.id AS ID_0 FROM categories c0_ WHERE c0_.parent_categorie_id = 4;

SELECT c0_.id AS ID_0 FROM categories c0_ WHERE c0_.parent_categorie_id = ?

[
  6
]

SELECT
  c0_.id AS ID_0
FROM
  categories c0_
WHERE
  c0_.parent_categorie_id = ?

SELECT c0_.id AS ID_0 FROM categories c0_ WHERE c0_.parent_categorie_id = 6;

SELECT a.* FROM (SELECT q0_.id AS ID_0, q0_.title AS TITLE_1, q0_.description AS DESCRIPTION_2, q0_.created_at AS CREATED_AT_3, a1_.id AS ID_4, a1_.description AS DESCRIPTION_5, a1_.created_at AS CREATED_AT_6, u2_.id AS ID_7, u2_.username AS USERNAME_8, u2_.userscu AS USERSCU_9, u2_.created_at AS CREATED_AT_10, u2_.updated_at AS UPDATED_AT_11, u2_.deleted AS DELETED_12, q0_.category_id AS CATEGORY_ID_13, q0_.creator_id AS CREATOR_ID_14, a1_.question_id AS QUESTION_ID_15, a1_.parent_answer_id AS PARENT_ANSWER_ID_16, a1_.creator_id AS CREATOR_ID_17, u2_.role_id AS ROLE_ID_18 FROM questions q0_ LEFT JOIN answers a1_ ON q0_.id = a1_.question_id LEFT JOIN users u2_ ON q0_.creator_id = u2_.id WHERE q0_.category_id IN (?, ?) ORDER BY q0_.id ASC) a WHERE ROWNUM <= 20

[
  4
  6
]

SELECT
  a.*
FROM
  (
    SELECT
      q0_.id AS ID_0,
      q0_.title AS TITLE_1,
      q0_.description AS DESCRIPTION_2,
      q0_.created_at AS CREATED_AT_3,
      a1_.id AS ID_4,
      a1_.description AS DESCRIPTION_5,
      a1_.created_at AS CREATED_AT_6,
      u2_.id AS ID_7,
      u2_.username AS USERNAME_8,
      u2_.userscu AS USERSCU_9,
      u2_.created_at AS CREATED_AT_10,
      u2_.updated_at AS UPDATED_AT_11,
      u2_.deleted AS DELETED_12,
      q0_.category_id AS CATEGORY_ID_13,
      q0_.creator_id AS CREATOR_ID_14,
      a1_.question_id AS QUESTION_ID_15,
      a1_.parent_answer_id AS PARENT_ANSWER_ID_16,
      a1_.creator_id AS CREATOR_ID_17,
      u2_.role_id AS ROLE_ID_18
    FROM
      questions q0_
      LEFT JOIN answers a1_ ON q0_.id = a1_.question_id
      LEFT JOIN users u2_ ON q0_.creator_id = u2_.id
    WHERE
      q0_.category_id IN (?, ?)
    ORDER BY
      q0_.id ASC
  ) a
WHERE
  ROWNUM <= 20

SELECT a.* FROM (SELECT q0_.id AS ID_0, q0_.title AS TITLE_1, q0_.description AS DESCRIPTION_2, q0_.created_at AS CREATED_AT_3, a1_.id AS ID_4, a1_.description AS DESCRIPTION_5, a1_.created_at AS CREATED_AT_6, u2_.id AS ID_7, u2_.username AS USERNAME_8, u2_.userscu AS USERSCU_9, u2_.created_at AS CREATED_AT_10, u2_.updated_at AS UPDATED_AT_11, u2_.deleted AS DELETED_12, q0_.category_id AS CATEGORY_ID_13, q0_.creator_id AS CREATOR_ID_14, a1_.question_id AS QUESTION_ID_15, a1_.parent_answer_id AS PARENT_ANSWER_ID_16, a1_.creator_id AS CREATOR_ID_17, u2_.role_id AS ROLE_ID_18 FROM questions q0_ LEFT JOIN answers a1_ ON q0_.id = a1_.question_id LEFT JOIN users u2_ ON q0_.creator_id = u2_.id WHERE q0_.category_id IN (4, 6) ORDER BY q0_.id ASC) a WHERE ROWNUM <= 20;

SELECT COUNT(q0_.id) AS SCLR_0 FROM questions q0_ LEFT JOIN answers a1_ ON q0_.id = a1_.question_id WHERE q0_.category_id IN (?, ?)

[
  4
  6
]

SELECT
  COUNT(q0_.id) AS SCLR_0
FROM
  questions q0_
  LEFT JOIN answers a1_ ON q0_.id = a1_.question_id
WHERE
  q0_.category_id IN (?, ?)

SELECT COUNT(q0_.id) AS SCLR_0 FROM questions q0_ LEFT JOIN answers a1_ ON q0_.id = a1_.question_id WHERE q0_.category_id IN (4, 6);

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 = ?

[
  4
]

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 = 4;