Symfony Profiler

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

Query Metrics

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO messenger_core (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id

[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:2:{s:53:\"Symfony\\Component\\Messenger\\Stamp\\TransportNamesStamp\";a:1:{i:0;O:53:\"Symfony\\Component\\Messenger\\Stamp\\TransportNamesStamp\":1:{s:69:\"\0Symfony\\Component\\Messenger\\Stamp\\TransportNamesStamp\0transportNames\";a:1:{i:0;s:9:\"async-low\";}}}s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:54:\"BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\":2:{s:65:\"\0BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\0namespace\";s:18:\"users-profile-user\";s:59:\"\0BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\0key\";s:40:\"ea1074c9def4a74cccd898325b80406d13cad070\";}}"
  "[]"
  "low"
  "2026-02-21 14:19:49"
  "2026-02-21 14:19:49"
]

INSERT INTO messenger_core (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?) RETURNING id

INSERT INTO messenger_core (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:2:{s:53:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\\";a:1:{i:0;O:53:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\\":1:{s:69:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\0transportNames\\\";a:1:{i:0;s:9:\\\"async-low\\\";}}}s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:54:\\\"BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\\":2:{s:65:\\\"\\0BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\0namespace\\\";s:18:\\\"users-profile-user\\\";s:59:\\\"\\0BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\0key\\\";s:40:\\\"ea1074c9def4a74cccd898325b80406d13cad070\\\";}}', '[]', 'low', '2026-02-21 14:19:49', '2026-02-21 14:19:49') RETURNING id;

SELECT pg_notify(?, ?)

[
  "messenger_core"
  "low"
]

SELECT
  pg_notify(?, ?)

SELECT pg_notify('messenger_core', 'low');

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT profile.id, profile_region.value AS region, profile_shop.value AS shop, profile_orders.value AS orders, profile_warehouse.value AS warehouse, region_trans.name AS region_name, users_profile_personal.location, users_profile_personal.latitude, users_profile_personal.longitude, JSON_AGG ( DISTINCT

                JSONB_BUILD_OBJECT
                (
                    'value', user_profile_value.value,
                    'name', user_profile_field_trans.name,
                    'type', user_profile_field.type
                )

            ) AS profile_value FROM users_profile profile INNER JOIN users_profile_info info ON info.profile = profile.id AND info.status = ? LEFT JOIN users_profile_event event ON event.id = profile.event INNER JOIN user_profile_region profile_region ON profile_region.event = profile.event LEFT JOIN user_profile_shop profile_shop ON profile_shop.event = profile.event LEFT JOIN user_profile_orders profile_orders ON profile_orders.event = profile.event LEFT JOIN user_profile_warehouse profile_warehouse ON profile_warehouse.event = profile.event LEFT JOIN users_profile_personal users_profile_personal ON users_profile_personal.event = profile.event LEFT JOIN users_profile_value user_profile_value ON user_profile_value.event = profile.event LEFT JOIN region region ON region.id = profile_region.value LEFT JOIN region_trans region_trans ON region_trans.event = region.event INNER JOIN type_users_profile_section_field user_profile_field ON 
                    user_profile_field.id = user_profile_value.field 
                    AND user_profile_field.card = true
                 LEFT JOIN type_users_profile_section_field_trans user_profile_field_trans ON 
                    user_profile_field_trans.field = user_profile_field.id 
                    AND user_profile_field_trans.local = ?
                 GROUP BY event.sort, profile.id, profile_region.value, profile_shop.value, profile_orders.value, profile_warehouse.value, region_trans.name, users_profile_personal.location, users_profile_personal.latitude, users_profile_personal.longitude ORDER BY CASE WHEN profile.id = ? THEN 0 ELSE 1 END, CASE WHEN profile_region.value = ? THEN 0 ELSE 1 END, profile_region.value, event.sort DESC

[
  "act"
  "ru"
  "01982ecf-0a6a-79e5-967b-4992d1b836bb"
  "201042a6-c35d-7bc4-9cb9-ef8bc1c8711e"
]

SELECT
  profile.id,
  profile_region.value AS region,
  profile_shop.value AS shop,
  profile_orders.value AS orders,
  profile_warehouse.value AS warehouse,
  region_trans.name AS region_name,
  users_profile_personal.location,
  users_profile_personal.latitude,
  users_profile_personal.longitude,
  JSON_AGG (
    DISTINCT JSONB_BUILD_OBJECT (
      'value', user_profile_value.value,
      'name', user_profile_field_trans.name,
      'type', user_profile_field.type
    )
  ) AS profile_value
FROM
  users_profile profile
  INNER JOIN users_profile_info info ON info.profile = profile.id
  AND info.status = ?
  LEFT JOIN users_profile_event event ON event.id = profile.event
  INNER JOIN user_profile_region profile_region ON profile_region.event = profile.event
  LEFT JOIN user_profile_shop profile_shop ON profile_shop.event = profile.event
  LEFT JOIN user_profile_orders profile_orders ON profile_orders.event = profile.event
  LEFT JOIN user_profile_warehouse profile_warehouse ON profile_warehouse.event = profile.event
  LEFT JOIN users_profile_personal users_profile_personal ON users_profile_personal.event = profile.event
  LEFT JOIN users_profile_value user_profile_value ON user_profile_value.event = profile.event
  LEFT JOIN region region ON region.id = profile_region.value
  LEFT JOIN region_trans region_trans ON region_trans.event = region.event
  INNER JOIN type_users_profile_section_field user_profile_field ON user_profile_field.id = user_profile_value.field
  AND user_profile_field.card = true
  LEFT JOIN type_users_profile_section_field_trans user_profile_field_trans ON user_profile_field_trans.field = user_profile_field.id
  AND user_profile_field_trans.local = ?
GROUP BY
  event.sort,
  profile.id,
  profile_region.value,
  profile_shop.value,
  profile_orders.value,
  profile_warehouse.value,
  region_trans.name,
  users_profile_personal.location,
  users_profile_personal.latitude,
  users_profile_personal.longitude
ORDER BY
  CASE WHEN profile.id = ? THEN
    0
  ELSE
    1
  END,
  CASE WHEN profile_region.value = ? THEN
    0
  ELSE
    1
  END,
  profile_region.value,
  event.sort DESC

SELECT profile.id, profile_region.value AS region, profile_shop.value AS shop, profile_orders.value AS orders, profile_warehouse.value AS warehouse, region_trans.name AS region_name, users_profile_personal.location, users_profile_personal.latitude, users_profile_personal.longitude, JSON_AGG ( DISTINCT

                JSONB_BUILD_OBJECT
                (
                    'value', user_profile_value.value,
                    'name', user_profile_field_trans.name,
                    'type', user_profile_field.type
                )

            ) AS profile_value FROM users_profile profile INNER JOIN users_profile_info info ON info.profile = profile.id AND info.status = 'act' LEFT JOIN users_profile_event event ON event.id = profile.event INNER JOIN user_profile_region profile_region ON profile_region.event = profile.event LEFT JOIN user_profile_shop profile_shop ON profile_shop.event = profile.event LEFT JOIN user_profile_orders profile_orders ON profile_orders.event = profile.event LEFT JOIN user_profile_warehouse profile_warehouse ON profile_warehouse.event = profile.event LEFT JOIN users_profile_personal users_profile_personal ON users_profile_personal.event = profile.event LEFT JOIN users_profile_value user_profile_value ON user_profile_value.event = profile.event LEFT JOIN region region ON region.id = profile_region.value LEFT JOIN region_trans region_trans ON region_trans.event = region.event INNER JOIN type_users_profile_section_field user_profile_field ON 
                    user_profile_field.id = user_profile_value.field 
                    AND user_profile_field.card = true
                 LEFT JOIN type_users_profile_section_field_trans user_profile_field_trans ON 
                    user_profile_field_trans.field = user_profile_field.id 
                    AND user_profile_field_trans.local = 'ru'
                 GROUP BY event.sort, profile.id, profile_region.value, profile_shop.value, profile_orders.value, profile_warehouse.value, region_trans.name, users_profile_personal.location, users_profile_personal.latitude, users_profile_personal.longitude ORDER BY CASE WHEN profile.id = '01982ecf-0a6a-79e5-967b-4992d1b836bb' THEN 0 ELSE 1 END, CASE WHEN profile_region.value = '201042a6-c35d-7bc4-9cb9-ef8bc1c8711e' THEN 0 ELSE 1 END, profile_region.value, event.sort DESC;