Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_id AS token_id_5, t0.token_password AS token_password_6, t0.blocked AS blocked_7, t0.token_auth AS token_auth_8 FROM users t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.token_id AS token_id_5,
  t0.token_password AS token_password_6,
  t0.blocked AS blocked_7,
  t0.token_auth AS token_auth_8
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_id AS token_id_5, t0.token_password AS token_password_6, t0.blocked AS blocked_7, t0.token_auth AS token_auth_8 FROM users t0 WHERE t0.id = 1;

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.cdn_code AS cdn_code_2, a0_.for_region AS for_region_3, a0_.cdn_name AS cdn_name_4, a0_.api_uri AS api_uri_5, a0_.use_total AS use_total_6, a0_.unit_id AS unit_id_7 FROM activity_type a0_

[]

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.cdn_code AS cdn_code_2,
  a0_.for_region AS for_region_3,
  a0_.cdn_name AS cdn_name_4,
  a0_.api_uri AS api_uri_5,
  a0_.use_total AS use_total_6,
  a0_.unit_id AS unit_id_7
FROM
  activity_type a0_

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.cdn_code AS cdn_code_2, a0_.for_region AS for_region_3, a0_.cdn_name AS cdn_name_4, a0_.api_uri AS api_uri_5, a0_.use_total AS use_total_6, a0_.unit_id AS unit_id_7 FROM activity_type a0_;

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM activity a0_ INNER JOIN project p1_ ON (a0_.project_id = p1_.id) INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id) INNER JOIN client c3_ ON (c2_.client_id = c3_.id) INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id)

[]

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  activity a0_
  INNER JOIN project p1_ ON (a0_.project_id = p1_.id)
  INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id)
  INNER JOIN client c3_ ON (c2_.client_id = c3_.id)
  INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM activity a0_ INNER JOIN project p1_ ON (a0_.project_id = p1_.id) INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id) INNER JOIN client c3_ ON (c2_.client_id = c3_.id) INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id);

SELECT DISTINCT a0_.id AS id_0 FROM activity a0_ INNER JOIN project p1_ ON (a0_.project_id = p1_.id) INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id) INNER JOIN client c3_ ON (c2_.client_id = c3_.id) INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id) LIMIT 20

[]

SELECT
  DISTINCT a0_.id AS id_0
FROM
  activity a0_
  INNER JOIN project p1_ ON (a0_.project_id = p1_.id)
  INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id)
  INNER JOIN client c3_ ON (c2_.client_id = c3_.id)
  INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id)
LIMIT
  20

SELECT DISTINCT a0_.id AS id_0 FROM activity a0_ INNER JOIN project p1_ ON (a0_.project_id = p1_.id) INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id) INNER JOIN client c3_ ON (c2_.client_id = c3_.id) INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id) LIMIT 20;

SELECT a0_.id AS id_0, CONCAT(c1_.name, CONCAT(' (', CONCAT(c1_.email, ')'))) AS sclr_1, p2_.short_name AS short_name_2, a0_.year AS year_3, a0_.month AS month_4, a3_.name AS name_5, a0_.json_data AS json_data_6 FROM activity a0_ INNER JOIN project p2_ ON (a0_.project_id = p2_.id) INNER JOIN contract c4_ ON (p2_.contract_id = c4_.id) INNER JOIN client c1_ ON (c4_.client_id = c1_.id) INNER JOIN activity_type a3_ ON (a0_.activity_type_id = a3_.id) WHERE a0_.id IN (?, ?)

[
  1
  2
]

SELECT
  a0_.id AS id_0,
  CONCAT(
    c1_.name,
    CONCAT(
      ' (',
      CONCAT(c1_.email, ')')
    )
  ) AS sclr_1,
  p2_.short_name AS short_name_2,
  a0_.year AS year_3,
  a0_.month AS month_4,
  a3_.name AS name_5,
  a0_.json_data AS json_data_6
FROM
  activity a0_
  INNER JOIN project p2_ ON (a0_.project_id = p2_.id)
  INNER JOIN contract c4_ ON (p2_.contract_id = c4_.id)
  INNER JOIN client c1_ ON (c4_.client_id = c1_.id)
  INNER JOIN activity_type a3_ ON (a0_.activity_type_id = a3_.id)
WHERE
  a0_.id IN (?, ?)

SELECT a0_.id AS id_0, CONCAT(c1_.name, CONCAT(' (', CONCAT(c1_.email, ')'))) AS sclr_1, p2_.short_name AS short_name_2, a0_.year AS year_3, a0_.month AS month_4, a3_.name AS name_5, a0_.json_data AS json_data_6 FROM activity a0_ INNER JOIN project p2_ ON (a0_.project_id = p2_.id) INNER JOIN contract c4_ ON (p2_.contract_id = c4_.id) INNER JOIN client c1_ ON (c4_.client_id = c1_.id) INNER JOIN activity_type a3_ ON (a0_.activity_type_id = a3_.id) WHERE a0_.id IN (1, 2);

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.rus_name AS rus_name_4, t0.env AS env_5 FROM settings t0 WHERE t0.name = ? LIMIT 1

[
  "current_month"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.rus_name AS rus_name_4,
  t0.env AS env_5
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.rus_name AS rus_name_4, t0.env AS env_5 FROM settings t0 WHERE t0.name = 'current_month' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.rus_name AS rus_name_4, t0.env AS env_5 FROM settings t0 WHERE t0.name = ? LIMIT 1

[
  "current_month"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.rus_name AS rus_name_4,
  t0.env AS env_5
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.rus_name AS rus_name_4, t0.env AS env_5 FROM settings t0 WHERE t0.name = 'current_month' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.rus_name AS rus_name_4, t0.env AS env_5 FROM settings t0 WHERE t0.name = ? LIMIT 1

[
  "database_name"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.rus_name AS rus_name_4,
  t0.env AS env_5
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.rus_name AS rus_name_4, t0.env AS env_5 FROM settings t0 WHERE t0.name = 'database_name' LIMIT 1;