Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 11
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 3
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1

[
  "ru"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.full_name AS full_name_3
FROM
  lang t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = 'ru' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.id = ?

[
  7
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.img AS img_3,
  t0.parent_id AS parent_id_4,
  t0.is_deleted AS is_deleted_5,
  t0.parent_id AS parent_id_6
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.id = 7;

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.surname AS surname_2, u0_.birthday AS birthday_3, u0_.gender AS gender_4, u0_.img AS img_5, u0_.phone_number AS phone_number_6, u0_.balance AS balance_7, u0_.work_experience AS work_experience_8, u0_.self AS self_9, u0_.role AS role_10, u0_.token AS token_11, u0_.latitude AS latitude_12, u0_.longitude AS longitude_13, u0_.push_token AS push_token_14, u0_.work_imgs AS work_imgs_15, u0_.city_name AS city_name_16, u0_.register_date AS register_date_17, u0_.ban_text AS ban_text_18, u0_.b AS b_19, u0_.city_id AS city_id_20, u0_.lang_id AS lang_id_21 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = ? AND u0_.role = ?

[
  7
  2
]

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.surname AS surname_2,
  u0_.birthday AS birthday_3,
  u0_.gender AS gender_4,
  u0_.img AS img_5,
  u0_.phone_number AS phone_number_6,
  u0_.balance AS balance_7,
  u0_.work_experience AS work_experience_8,
  u0_.self AS self_9,
  u0_.role AS role_10,
  u0_.token AS token_11,
  u0_.latitude AS latitude_12,
  u0_.longitude AS longitude_13,
  u0_.push_token AS push_token_14,
  u0_.work_imgs AS work_imgs_15,
  u0_.city_name AS city_name_16,
  u0_.register_date AS register_date_17,
  u0_.ban_text AS ban_text_18,
  u0_.b AS b_19,
  u0_.city_id AS city_id_20,
  u0_.lang_id AS lang_id_21
FROM
  user u0_
  INNER JOIN user_category u2_ ON u0_.id = u2_.user_id
  INNER JOIN category c1_ ON c1_.id = u2_.category_id
WHERE
  c1_.id = ?
  AND u0_.role = ?

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.surname AS surname_2, u0_.birthday AS birthday_3, u0_.gender AS gender_4, u0_.img AS img_5, u0_.phone_number AS phone_number_6, u0_.balance AS balance_7, u0_.work_experience AS work_experience_8, u0_.self AS self_9, u0_.role AS role_10, u0_.token AS token_11, u0_.latitude AS latitude_12, u0_.longitude AS longitude_13, u0_.push_token AS push_token_14, u0_.work_imgs AS work_imgs_15, u0_.city_name AS city_name_16, u0_.register_date AS register_date_17, u0_.ban_text AS ban_text_18, u0_.b AS b_19, u0_.city_id AS city_id_20, u0_.lang_id AS lang_id_21 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = 7 AND u0_.role = 2;

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = ? AND u0_.role = ?

[
  7
  2
]

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
  INNER JOIN user_category u2_ ON u0_.id = u2_.user_id
  INNER JOIN category c1_ ON c1_.id = u2_.category_id
WHERE
  c1_.id = ?
  AND u0_.role = ?

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = 7 AND u0_.role = 2;

SELECT DISTINCT u0_.id AS id_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = ? AND u0_.role = ? LIMIT 10

[
  7
  2
]

SELECT
  DISTINCT u0_.id AS id_0
FROM
  user u0_
  INNER JOIN user_category u2_ ON u0_.id = u2_.user_id
  INNER JOIN category c1_ ON c1_.id = u2_.category_id
WHERE
  c1_.id = ?
  AND u0_.role = ?
LIMIT
  10

SELECT DISTINCT u0_.id AS id_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = 7 AND u0_.role = 2 LIMIT 10;