Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 94
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 5
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Blocks 0
• Message Flow
• Configuration

Query Metrics

SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.vk_profile_imported AS vk_profile_imported_17, u0_.vk_confirmed AS vk_confirmed_18, u0_.first_jwt_at AS first_jwt_at_19, u0_.new_email AS new_email_20, u0_.new_email_token AS new_email_token_21, u0_.status AS status_22, u0_.block_reason AS block_reason_23, u0_.role AS role_24, u0_.last_visit_at AS last_visit_at_25, u0_.activity_status AS activity_status_26, u0_.confirm_token_token AS confirm_token_token_27, u0_.confirm_token_expires AS confirm_token_expires_28, u0_.name_first AS name_first_29, u0_.name_last AS name_last_30, u0_.name_middle AS name_middle_31, u0_.avatar_small_hash AS avatar_small_hash_32, u0_.avatar_original_hash AS avatar_original_hash_33, u0_.reset_token_token AS reset_token_token_34, u0_.reset_token_expires AS reset_token_expires_35, u0_.city_id AS city_id_36 FROM "user_users" u0_ WHERE u0_.email = ?

[
  "usmian@yandex.ru"
]

SELECT
  u0_.id AS id_0,
  u0_.public_number AS public_number_1,
  u0_.date AS date_2,
  u0_.email AS email_3,
  u0_.phone AS phone_4,
  u0_.phone_numeric AS phone_numeric_5,
  u0_.privacy_mask AS privacy_mask_6,
  u0_.push_settings_mask AS push_settings_mask_7,
  u0_.publish_daily_count AS publish_daily_count_8,
  u0_.publish_daily_at AS publish_daily_at_9,
  u0_.settings AS settings_10,
  u0_.password AS password_11,
  u0_.about AS about_12,
  u0_.stuff AS stuff_13,
  u0_.vk_code_verifier AS vk_code_verifier_14,
  u0_.vk_id AS vk_id_15,
  u0_.vk_avatar AS vk_avatar_16,
  u0_.vk_profile_imported AS vk_profile_imported_17,
  u0_.vk_confirmed AS vk_confirmed_18,
  u0_.first_jwt_at AS first_jwt_at_19,
  u0_.new_email AS new_email_20,
  u0_.new_email_token AS new_email_token_21,
  u0_.status AS status_22,
  u0_.block_reason AS block_reason_23,
  u0_.role AS role_24,
  u0_.last_visit_at AS last_visit_at_25,
  u0_.activity_status AS activity_status_26,
  u0_.confirm_token_token AS confirm_token_token_27,
  u0_.confirm_token_expires AS confirm_token_expires_28,
  u0_.name_first AS name_first_29,
  u0_.name_last AS name_last_30,
  u0_.name_middle AS name_middle_31,
  u0_.avatar_small_hash AS avatar_small_hash_32,
  u0_.avatar_original_hash AS avatar_original_hash_33,
  u0_.reset_token_token AS reset_token_token_34,
  u0_.reset_token_expires AS reset_token_expires_35,
  u0_.city_id AS city_id_36
FROM
  "user_users" u0_
WHERE
  u0_.email = ?

SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.vk_profile_imported AS vk_profile_imported_17, u0_.vk_confirmed AS vk_confirmed_18, u0_.first_jwt_at AS first_jwt_at_19, u0_.new_email AS new_email_20, u0_.new_email_token AS new_email_token_21, u0_.status AS status_22, u0_.block_reason AS block_reason_23, u0_.role AS role_24, u0_.last_visit_at AS last_visit_at_25, u0_.activity_status AS activity_status_26, u0_.confirm_token_token AS confirm_token_token_27, u0_.confirm_token_expires AS confirm_token_expires_28, u0_.name_first AS name_first_29, u0_.name_last AS name_last_30, u0_.name_middle AS name_middle_31, u0_.avatar_small_hash AS avatar_small_hash_32, u0_.avatar_original_hash AS avatar_original_hash_33, u0_.reset_token_token AS reset_token_token_34, u0_.reset_token_expires AS reset_token_expires_35, u0_.city_id AS city_id_36 FROM "user_users" u0_ WHERE u0_.email = 'usmian@yandex.ru';

SELECT DISTINCT id_0, MIN(sclr_6) AS dctrn_minrownum FROM (SELECT u0_.id AS id_0, u0_.type AS type_1, u0_.entity_id AS entity_id_2, u0_.is_viewed AS is_viewed_3, u0_.payload AS payload_4, u0_.created_at AS created_at_5, ROW_NUMBER() OVER(ORDER BY u0_.is_viewed ASC, u0_.created_at DESC) AS sclr_6 FROM "user_user_notifications" u0_ WHERE u0_.user_id = ?) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100

[
  "019efb3d-4132-79dd-abed-2f5eb76ecd0c"
]

SELECT
  DISTINCT id_0,
  MIN(sclr_6) AS dctrn_minrownum
FROM
  (
    SELECT
      u0_.id AS id_0,
      u0_.type AS type_1,
      u0_.entity_id AS entity_id_2,
      u0_.is_viewed AS is_viewed_3,
      u0_.payload AS payload_4,
      u0_.created_at AS created_at_5,
      ROW_NUMBER() OVER(
        ORDER BY
          u0_.is_viewed ASC,
          u0_.created_at DESC
      ) AS sclr_6
    FROM
      "user_user_notifications" u0_
    WHERE
      u0_.user_id = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  100

SELECT DISTINCT id_0, MIN(sclr_6) AS dctrn_minrownum FROM (SELECT u0_.id AS id_0, u0_.type AS type_1, u0_.entity_id AS entity_id_2, u0_.is_viewed AS is_viewed_3, u0_.payload AS payload_4, u0_.created_at AS created_at_5, ROW_NUMBER() OVER(ORDER BY u0_.is_viewed ASC, u0_.created_at DESC) AS sclr_6 FROM "user_user_notifications" u0_ WHERE u0_.user_id = '019efb3d-4132-79dd-abed-2f5eb76ecd0c') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100;

SELECT u0_.id AS id_0, u0_.type AS type_1, u0_.entity_id AS entity_id_2, u0_.is_viewed AS is_viewed_3, u0_.payload AS payload_4, u0_.created_at AS created_at_5, u0_.user_id AS user_id_6 FROM "user_user_notifications" u0_ WHERE u0_.user_id = ? AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.is_viewed ASC, u0_.created_at DESC

[
  "019efb3d-4132-79dd-abed-2f5eb76ecd0c"
  "01a04499-f2b8-7f61-bc52-a5167e84f5e6"
  "01a04499-d7ac-778a-b3a4-8e3fb8e9dfc4"
  "01a04486-1462-71d4-b660-bd16cc2948c3"
  "01a03a8a-e0b1-774b-b669-75848792bdfa"
  "01a02bb9-8e01-7bb1-963d-9a8c2f87f7a1"
  "01a02ba1-17ad-7266-8e88-7610806ad100"
  "01a02a60-d1d0-7b90-88bc-899bd00a5802"
  "01a02011-6b10-74b6-b774-7a84f33275b6"
  "01a00b48-0ec6-73f9-bf9a-4c9715c18e36"
  "019fd58c-0686-7bf7-b639-2c2a746076cd"
  "019fd307-b171-718a-abf1-19d5bce4543d"
  "019fcdf6-6627-7b69-bd1f-5e59a5716ae0"
]

SELECT
  u0_.id AS id_0,
  u0_.type AS type_1,
  u0_.entity_id AS entity_id_2,
  u0_.is_viewed AS is_viewed_3,
  u0_.payload AS payload_4,
  u0_.created_at AS created_at_5,
  u0_.user_id AS user_id_6
FROM
  "user_user_notifications" u0_
WHERE
  u0_.user_id = ?
  AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  u0_.is_viewed ASC,
  u0_.created_at DESC

SELECT u0_.id AS id_0, u0_.type AS type_1, u0_.entity_id AS entity_id_2, u0_.is_viewed AS is_viewed_3, u0_.payload AS payload_4, u0_.created_at AS created_at_5, u0_.user_id AS user_id_6 FROM "user_user_notifications" u0_ WHERE u0_.user_id = '019efb3d-4132-79dd-abed-2f5eb76ecd0c' AND u0_.id IN ('01a04499-f2b8-7f61-bc52-a5167e84f5e6', '01a04499-d7ac-778a-b3a4-8e3fb8e9dfc4', '01a04486-1462-71d4-b660-bd16cc2948c3', '01a03a8a-e0b1-774b-b669-75848792bdfa', '01a02bb9-8e01-7bb1-963d-9a8c2f87f7a1', '01a02ba1-17ad-7266-8e88-7610806ad100', '01a02a60-d1d0-7b90-88bc-899bd00a5802', '01a02011-6b10-74b6-b774-7a84f33275b6', '01a00b48-0ec6-73f9-bf9a-4c9715c18e36', '019fd58c-0686-7bf7-b639-2c2a746076cd', '019fd307-b171-718a-abf1-19d5bce4543d', '019fcdf6-6627-7b69-bd1f-5e59a5716ae0') ORDER BY u0_.is_viewed ASC, u0_.created_at DESC;

SELECT i.id, i.status FROM item_items i WHERE i.id IN (?, ?, ?)

[
  "01a025de-785b-779d-be93-4ea079f6e122"
  "01a01f9e-e579-7607-a04f-f6ce81f8c5fe"
  "019de498-d869-0ac7-7171-0b23db391559"
]

SELECT
  i.id,
  i.status
FROM
  item_items i
WHERE
  i.id IN (?, ?, ?)

SELECT i.id, i.status FROM item_items i WHERE i.id IN ('01a025de-785b-779d-be93-4ea079f6e122', '01a01f9e-e579-7607-a04f-f6ce81f8c5fe', '019de498-d869-0ac7-7171-0b23db391559');

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.type AS type_1, u0_.entity_id AS entity_id_2, u0_.is_viewed AS is_viewed_3, u0_.payload AS payload_4, u0_.created_at AS created_at_5 FROM "user_user_notifications" u0_ WHERE u0_.user_id = ? ORDER BY u0_.is_viewed ASC, u0_.created_at DESC) dctrn_result) dctrn_table

[
  "019efb3d-4132-79dd-abed-2f5eb76ecd0c"
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          u0_.id AS id_0,
          u0_.type AS type_1,
          u0_.entity_id AS entity_id_2,
          u0_.is_viewed AS is_viewed_3,
          u0_.payload AS payload_4,
          u0_.created_at AS created_at_5
        FROM
          "user_user_notifications" u0_
        WHERE
          u0_.user_id = ?
        ORDER BY
          u0_.is_viewed ASC,
          u0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.type AS type_1, u0_.entity_id AS entity_id_2, u0_.is_viewed AS is_viewed_3, u0_.payload AS payload_4, u0_.created_at AS created_at_5 FROM "user_user_notifications" u0_ WHERE u0_.user_id = '019efb3d-4132-79dd-abed-2f5eb76ecd0c' ORDER BY u0_.is_viewed ASC, u0_.created_at DESC) dctrn_result) dctrn_table;