Symfony Profiler

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

Query Metrics

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"
  "019469c3-700f-76a9-9b34-ccde7b4e6f49"
  "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 = '019469c3-700f-76a9-9b34-ccde7b4e6f49' 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;