Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client 1
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.name AS name_4, t0.is_active AS is_active_5, t0.last_login_at AS last_login_at_6, t0.created_at AS created_at_7, t0.password AS password_8 FROM admin_user t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.name AS name_4,
  t0.is_active AS is_active_5,
  t0.last_login_at AS last_login_at_6,
  t0.created_at AS created_at_7,
  t0.password AS password_8
FROM
  admin_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.name AS name_4, t0.is_active AS is_active_5, t0.last_login_at AS last_login_at_6, t0.created_at AS created_at_7, t0.password AS password_8 FROM admin_user t0 WHERE t0.id = 2;

SELECT u0_.id AS id_0 FROM "user" u0_ WHERE u0_.phone_hash IN (?, ?, ?)

[
  "c1efc49c8aea0851aac696afc3e6bd9751e08136b264ba800cca80fb4a1c1e2f"
  "9e35026d9e3d9ccdf00a0f530cd7d91b01e5be02b075b7b783fb4b53f20b1cfe"
  "e5a38a807ceca851191a70f8efbd96431ec0dd1f1c3b971c36dab723bceb9690"
]

SELECT
  u0_.id AS id_0
FROM
  "user" u0_
WHERE
  u0_.phone_hash IN (?, ?, ?)

SELECT u0_.id AS id_0 FROM "user" u0_ WHERE u0_.phone_hash IN ('c1efc49c8aea0851aac696afc3e6bd9751e08136b264ba800cca80fb4a1c1e2f', '9e35026d9e3d9ccdf00a0f530cd7d91b01e5be02b075b7b783fb4b53f20b1cfe', 'e5a38a807ceca851191a70f8efbd96431ec0dd1f1c3b971c36dab723bceb9690');

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.surname AS surname_3, t0.patronymic AS patronymic_4, t0.date_birth AS date_birth_5, t0.email AS email_6, t0.email_hash AS email_hash_7, t0.phone AS phone_8, t0.phone_hash AS phone_hash_9, t0.status AS status_10, t0.verification_status AS verification_status_11, t0.bonus AS bonus_12, t0.notification_subscription_status AS notification_subscription_status_13, t0.created_at AS created_at_14, t0.last_activity_at AS last_activity_at_15, t0.is_guest AS is_guest_16, t0.external_uid AS external_uid_17, t0.roles AS roles_18, t0.vk_id AS vk_id_19, t0.vk_id_hash AS vk_id_hash_20, t0.is_pin_enabled AS is_pin_enabled_21, t0.is_biometry_enabled AS is_biometry_enabled_22, t0.email_updated_at AS email_updated_at_23, t0.email_requested_at AS email_requested_at_24, t0.gender AS gender_25, t0.is_evaluation_on_catalog AS is_evaluation_on_catalog_26, t0.last_platform_presentation_at AS last_platform_presentation_at_27, t0.last_dealer_id AS last_dealer_id_28, t0.city_id AS city_id_29, t0.registration_city_id AS registration_city_id_30 FROM "user" t0 WHERE t0.id = ?

[
  760
]

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.surname AS surname_3,
  t0.patronymic AS patronymic_4,
  t0.date_birth AS date_birth_5,
  t0.email AS email_6,
  t0.email_hash AS email_hash_7,
  t0.phone AS phone_8,
  t0.phone_hash AS phone_hash_9,
  t0.status AS status_10,
  t0.verification_status AS verification_status_11,
  t0.bonus AS bonus_12,
  t0.notification_subscription_status AS notification_subscription_status_13,
  t0.created_at AS created_at_14,
  t0.last_activity_at AS last_activity_at_15,
  t0.is_guest AS is_guest_16,
  t0.external_uid AS external_uid_17,
  t0.roles AS roles_18,
  t0.vk_id AS vk_id_19,
  t0.vk_id_hash AS vk_id_hash_20,
  t0.is_pin_enabled AS is_pin_enabled_21,
  t0.is_biometry_enabled AS is_biometry_enabled_22,
  t0.email_updated_at AS email_updated_at_23,
  t0.email_requested_at AS email_requested_at_24,
  t0.gender AS gender_25,
  t0.is_evaluation_on_catalog AS is_evaluation_on_catalog_26,
  t0.last_platform_presentation_at AS last_platform_presentation_at_27,
  t0.last_dealer_id AS last_dealer_id_28,
  t0.city_id AS city_id_29,
  t0.registration_city_id AS registration_city_id_30
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.surname AS surname_3, t0.patronymic AS patronymic_4, t0.date_birth AS date_birth_5, t0.email AS email_6, t0.email_hash AS email_hash_7, t0.phone AS phone_8, t0.phone_hash AS phone_hash_9, t0.status AS status_10, t0.verification_status AS verification_status_11, t0.bonus AS bonus_12, t0.notification_subscription_status AS notification_subscription_status_13, t0.created_at AS created_at_14, t0.last_activity_at AS last_activity_at_15, t0.is_guest AS is_guest_16, t0.external_uid AS external_uid_17, t0.roles AS roles_18, t0.vk_id AS vk_id_19, t0.vk_id_hash AS vk_id_hash_20, t0.is_pin_enabled AS is_pin_enabled_21, t0.is_biometry_enabled AS is_biometry_enabled_22, t0.email_updated_at AS email_updated_at_23, t0.email_requested_at AS email_requested_at_24, t0.gender AS gender_25, t0.is_evaluation_on_catalog AS is_evaluation_on_catalog_26, t0.last_platform_presentation_at AS last_platform_presentation_at_27, t0.last_dealer_id AS last_dealer_id_28, t0.city_id AS city_id_29, t0.registration_city_id AS registration_city_id_30 FROM "user" t0 WHERE t0.id = 760;

SELECT nextval('pii_access_log_id_seq')

[]

SELECT
  nextval('pii_access_log_id_seq')

SELECT nextval('pii_access_log_id_seq');

INSERT INTO pii_access_log (id, admin_user_id, operator, source, target_user_id, lookup_by, reason, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?)

[
  12
  2
  "admin"
  "admin"
  760
  "phone"
  "Консоль запросов: Профиль"
  "2026-10-07 12:52:10"
]

INSERT INTO pii_access_log (
  id, admin_user_id, operator, source,
  target_user_id, lookup_by, reason,
  created_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO pii_access_log (id, admin_user_id, operator, source, target_user_id, lookup_by, reason, created_at) VALUES (12, 2, 'admin', 'admin', 760, 'phone', 'Консоль запросов: Профиль', '2026-10-07 12:52:10');

SELECT d0_.client_timezone AS client_timezone_0, CASE WHEN d0_.status = ? THEN 0 ELSE 1 END AS sclr_1, COALESCE(d0_.last_activity_at, d0_.created_at) AS sclr_2 FROM device d0_ WHERE d0_.user_id = ? AND d0_.client_timezone IS NOT NULL ORDER BY sclr_1 ASC, sclr_2 DESC, d0_.id DESC LIMIT 1

[
  10
  760
]

SELECT
  d0_.client_timezone AS client_timezone_0,
  CASE WHEN d0_.status = ? THEN
    0
  ELSE
    1
  END AS sclr_1,
  COALESCE(
    d0_.last_activity_at, d0_.created_at
  ) AS sclr_2
FROM
  device d0_
WHERE
  d0_.user_id = ?
  AND d0_.client_timezone IS NOT NULL
ORDER BY
  sclr_1 ASC,
  sclr_2 DESC,
  d0_.id DESC
LIMIT
  1

SELECT d0_.client_timezone AS client_timezone_0, CASE WHEN d0_.status = 10 THEN 0 ELSE 1 END AS sclr_1, COALESCE(d0_.last_activity_at, d0_.created_at) AS sclr_2 FROM device d0_ WHERE d0_.user_id = 760 AND d0_.client_timezone IS NOT NULL ORDER BY sclr_1 ASC, sclr_2 DESC, d0_.id DESC LIMIT 1;