Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.date AS date_1,
  u0_.email AS email_2,
  u0_.phone AS phone_3,
  u0_.phone_numeric AS phone_numeric_4,
  u0_.privacy_mask AS privacy_mask_5,
  u0_.push_settings_mask AS push_settings_mask_6,
  u0_.password AS password_7,
  u0_.about AS about_8,
  u0_.stuff AS stuff_9,
  u0_.vk_code_verifier AS vk_code_verifier_10,
  u0_.vk_id AS vk_id_11,
  u0_.vk_avatar AS vk_avatar_12,
  u0_.new_email AS new_email_13,
  u0_.new_email_token AS new_email_token_14,
  u0_.status AS status_15,
  u0_.role AS role_16,
  u0_.is_online AS is_online_17,
  u0_.last_visit AS last_visit_18,
  u0_.last_visit_at AS last_visit_at_19,
  u0_.confirm_token_token AS confirm_token_token_20,
  u0_.confirm_token_expires AS confirm_token_expires_21,
  u0_.name_first AS name_first_22,
  u0_.name_last AS name_last_23,
  u0_.name_middle AS name_middle_24,
  u0_.avatar_small_hash AS avatar_small_hash_25,
  u0_.avatar_original_hash AS avatar_original_hash_26,
  u0_.reset_token_token AS reset_token_token_27,
  u0_.reset_token_expires AS reset_token_expires_28,
  u0_.city_id AS city_id_29
FROM
  "user_users" u0_
WHERE
  u0_.email = ?

SELECT u0_.id AS id_0, u0_.date AS date_1, u0_.email AS email_2, u0_.phone AS phone_3, u0_.phone_numeric AS phone_numeric_4, u0_.privacy_mask AS privacy_mask_5, u0_.push_settings_mask AS push_settings_mask_6, u0_.password AS password_7, u0_.about AS about_8, u0_.stuff AS stuff_9, u0_.vk_code_verifier AS vk_code_verifier_10, u0_.vk_id AS vk_id_11, u0_.vk_avatar AS vk_avatar_12, u0_.new_email AS new_email_13, u0_.new_email_token AS new_email_token_14, u0_.status AS status_15, u0_.role AS role_16, u0_.is_online AS is_online_17, u0_.last_visit AS last_visit_18, u0_.last_visit_at AS last_visit_at_19, u0_.confirm_token_token AS confirm_token_token_20, u0_.confirm_token_expires AS confirm_token_expires_21, u0_.name_first AS name_first_22, u0_.name_last AS name_last_23, u0_.name_middle AS name_middle_24, u0_.avatar_small_hash AS avatar_small_hash_25, u0_.avatar_original_hash AS avatar_original_hash_26, u0_.reset_token_token AS reset_token_token_27, u0_.reset_token_expires AS reset_token_expires_28, u0_.city_id AS city_id_29 FROM "user_users" u0_ WHERE u0_.email = '80e51a4e-1b0b-456a-93dd-210d099ca9ed@775d2008-9edb-4e71-bccf-e3a51be771ba.com';

SELECT
  u0_.id AS id_0,
  u0_.date AS date_1,
  u0_.email AS email_2,
  u0_.phone AS phone_3,
  u0_.phone_numeric AS phone_numeric_4,
  u0_.privacy_mask AS privacy_mask_5,
  u0_.push_settings_mask AS push_settings_mask_6,
  u0_.password AS password_7,
  u0_.about AS about_8,
  u0_.stuff AS stuff_9,
  u0_.vk_code_verifier AS vk_code_verifier_10,
  u0_.vk_id AS vk_id_11,
  u0_.vk_avatar AS vk_avatar_12,
  u0_.new_email AS new_email_13,
  u0_.new_email_token AS new_email_token_14,
  u0_.status AS status_15,
  u0_.role AS role_16,
  u0_.is_online AS is_online_17,
  u0_.last_visit AS last_visit_18,
  u0_.last_visit_at AS last_visit_at_19,
  u0_.confirm_token_token AS confirm_token_token_20,
  u0_.confirm_token_expires AS confirm_token_expires_21,
  u0_.name_first AS name_first_22,
  u0_.name_last AS name_last_23,
  u0_.name_middle AS name_middle_24,
  u0_.avatar_small_hash AS avatar_small_hash_25,
  u0_.avatar_original_hash AS avatar_original_hash_26,
  u0_.reset_token_token AS reset_token_token_27,
  u0_.reset_token_expires AS reset_token_expires_28,
  u0_.city_id AS city_id_29
FROM
  "user_users" u0_
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.date AS date_1, u0_.email AS email_2, u0_.phone AS phone_3, u0_.phone_numeric AS phone_numeric_4, u0_.privacy_mask AS privacy_mask_5, u0_.push_settings_mask AS push_settings_mask_6, u0_.password AS password_7, u0_.about AS about_8, u0_.stuff AS stuff_9, u0_.vk_code_verifier AS vk_code_verifier_10, u0_.vk_id AS vk_id_11, u0_.vk_avatar AS vk_avatar_12, u0_.new_email AS new_email_13, u0_.new_email_token AS new_email_token_14, u0_.status AS status_15, u0_.role AS role_16, u0_.is_online AS is_online_17, u0_.last_visit AS last_visit_18, u0_.last_visit_at AS last_visit_at_19, u0_.confirm_token_token AS confirm_token_token_20, u0_.confirm_token_expires AS confirm_token_expires_21, u0_.name_first AS name_first_22, u0_.name_last AS name_last_23, u0_.name_middle AS name_middle_24, u0_.avatar_small_hash AS avatar_small_hash_25, u0_.avatar_original_hash AS avatar_original_hash_26, u0_.reset_token_token AS reset_token_token_27, u0_.reset_token_expires AS reset_token_expires_28, u0_.city_id AS city_id_29 FROM "user_users" u0_ WHERE u0_.id = '73ee8243-c222-4e78-8531-b0b1108d27bc';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  "user_users"
SET
  last_visit_at = ?
WHERE
  id = ?

UPDATE "user_users" SET last_visit_at = '2026-05-03 09:32:33' WHERE id = '73ee8243-c222-4e78-8531-b0b1108d27bc';

"COMMIT"

"COMMIT";

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 = '73ee8243-c222-4e78-8531-b0b1108d27bc') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100;

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 = '73ee8243-c222-4e78-8531-b0b1108d27bc' ORDER BY u0_.is_viewed ASC, u0_.created_at DESC) dctrn_result) dctrn_table;