Symfony Profiler

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_.new_email AS new_email_17,
  u0_.new_email_token AS new_email_token_18,
  u0_.status AS status_19,
  u0_.role AS role_20,
  u0_.is_online AS is_online_21,
  u0_.last_visit AS last_visit_22,
  u0_.last_visit_at AS last_visit_at_23,
  u0_.confirm_token_token AS confirm_token_token_24,
  u0_.confirm_token_expires AS confirm_token_expires_25,
  u0_.name_first AS name_first_26,
  u0_.name_last AS name_last_27,
  u0_.name_middle AS name_middle_28,
  u0_.avatar_small_hash AS avatar_small_hash_29,
  u0_.avatar_original_hash AS avatar_original_hash_30,
  u0_.reset_token_token AS reset_token_token_31,
  u0_.reset_token_expires AS reset_token_expires_32,
  u0_.city_id AS city_id_33
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_.new_email AS new_email_17, u0_.new_email_token AS new_email_token_18, u0_.status AS status_19, u0_.role AS role_20, u0_.is_online AS is_online_21, u0_.last_visit AS last_visit_22, u0_.last_visit_at AS last_visit_at_23, u0_.confirm_token_token AS confirm_token_token_24, u0_.confirm_token_expires AS confirm_token_expires_25, u0_.name_first AS name_first_26, u0_.name_last AS name_last_27, u0_.name_middle AS name_middle_28, u0_.avatar_small_hash AS avatar_small_hash_29, u0_.avatar_original_hash AS avatar_original_hash_30, u0_.reset_token_token AS reset_token_token_31, u0_.reset_token_expires AS reset_token_expires_32, u0_.city_id AS city_id_33 FROM "user_users" u0_ WHERE u0_.email = 'usmian@yandex.ru';

SELECT
  a.id,
  a.initiator,
  a.recipient,
  a.recipient_message_counter,
  a.initiator_message_counter,
  a.created_at,
  a.updated_at,
  i.name_first as initiator_name,
  i.name_last as initiator_name_last,
  i.avatar_small_hash as initiator_avatar_small_hash,
  r.name_first as recipient_name,
  r.name_last as recipient_name_last,
  r.avatar_small_hash as recipient_avatar_small_hash,
  a.recipient_last_message_message_id,
  a.recipient_last_message_message,
  a.recipient_last_message_timestamp,
  a.recipient_last_message_updated_at,
  a.recipient_last_message_status,
  a.initiator_last_message_message_id,
  a.initiator_last_message_message,
  a.initiator_last_message_timestamp,
  a.initiator_last_message_updated_at,
  a.initiator_last_message_status
FROM
  user_conversations a
  LEFT JOIN user_users i ON a.initiator = i.id
  LEFT JOIN user_users r ON a.recipient = r.id
WHERE
  (
    (
      a.initiator = ?
      OR a.recipient = ?
    )
  )
  AND (a.status = ?)
  AND (
    EXISTS (
      SELECT
        1
      FROM
        user_messages m
      WHERE
        m.conversation = a.id
    )
    OR a.initiator = ?
    OR a.recipient = ?
  )
ORDER BY
  a.updated_at DESC,
  a.id DESC
LIMIT
  25

SELECT a.id, a.initiator, a.recipient, a.recipient_message_counter, a.initiator_message_counter, a.created_at, a.updated_at, i.name_first as initiator_name, i.name_last as initiator_name_last, i.avatar_small_hash as initiator_avatar_small_hash, r.name_first as recipient_name, r.name_last as recipient_name_last, r.avatar_small_hash as recipient_avatar_small_hash, a.recipient_last_message_message_id, a.recipient_last_message_message, a.recipient_last_message_timestamp, a.recipient_last_message_updated_at, a.recipient_last_message_status, a.initiator_last_message_message_id, a.initiator_last_message_message, a.initiator_last_message_timestamp, a.initiator_last_message_updated_at, a.initiator_last_message_status FROM user_conversations a LEFT JOIN user_users i ON a.initiator = i.id LEFT JOIN user_users r ON a.recipient = r.id WHERE ((a.initiator = '019efb3d-4132-79dd-abed-2f5eb76ecd0c' OR a.recipient = '019efb3d-4132-79dd-abed-2f5eb76ecd0c')) AND (a.status = 'active') AND (EXISTS (SELECT 1 FROM user_messages m WHERE m.conversation = a.id)
                OR a.initiator = '019deeab-5934-3cf0-ae98-dc6d872da1b4'
                OR a.recipient = '019deeab-5934-3cf0-ae98-dc6d872da1b4') ORDER BY a.updated_at DESC, a.id DESC LIMIT 25;

SELECT
  COUNT(DISTINCT a.id) AS total_results
FROM
  user_conversations a
  LEFT JOIN user_users i ON a.initiator = i.id
  LEFT JOIN user_users r ON a.recipient = r.id
WHERE
  (
    (
      a.initiator = ?
      OR a.recipient = ?
    )
  )
  AND (a.status = ?)
  AND (
    EXISTS (
      SELECT
        1
      FROM
        user_messages m
      WHERE
        m.conversation = a.id
    )
    OR a.initiator = ?
    OR a.recipient = ?
  )
LIMIT
  1

SELECT COUNT(DISTINCT a.id) AS total_results FROM user_conversations a LEFT JOIN user_users i ON a.initiator = i.id LEFT JOIN user_users r ON a.recipient = r.id WHERE ((a.initiator = '019efb3d-4132-79dd-abed-2f5eb76ecd0c' OR a.recipient = '019efb3d-4132-79dd-abed-2f5eb76ecd0c')) AND (a.status = 'active') AND (EXISTS (SELECT 1 FROM user_messages m WHERE m.conversation = a.id)
                OR a.initiator = '019deeab-5934-3cf0-ae98-dc6d872da1b4'
                OR a.recipient = '019deeab-5934-3cf0-ae98-dc6d872da1b4') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.public_number AS public_number_2,
  t0.date AS date_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.phone_numeric AS phone_numeric_6,
  t0.privacy_mask AS privacy_mask_7,
  t0.push_settings_mask AS push_settings_mask_8,
  t0.publish_daily_count AS publish_daily_count_9,
  t0.publish_daily_at AS publish_daily_at_10,
  t0.settings AS settings_11,
  t0.password AS password_12,
  t0.about AS about_13,
  t0.stuff AS stuff_14,
  t0.vk_code_verifier AS vk_code_verifier_15,
  t0.vk_id AS vk_id_16,
  t0.vk_avatar AS vk_avatar_17,
  t0.new_email AS new_email_18,
  t0.new_email_token AS new_email_token_19,
  t0.status AS status_20,
  t0.role AS role_21,
  t0.is_online AS is_online_22,
  t0.last_visit AS last_visit_23,
  t0.last_visit_at AS last_visit_at_24,
  t0.confirm_token_token AS confirm_token_token_25,
  t0.confirm_token_expires AS confirm_token_expires_26,
  t0.name_first AS name_first_27,
  t0.name_last AS name_last_28,
  t0.name_middle AS name_middle_29,
  t0.avatar_small_hash AS avatar_small_hash_30,
  t0.avatar_original_hash AS avatar_original_hash_31,
  t0.reset_token_token AS reset_token_token_32,
  t0.reset_token_expires AS reset_token_expires_33,
  t0.city_id AS city_id_34
FROM
  "user_users" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.public_number AS public_number_2, t0.date AS date_3, t0.email AS email_4, t0.phone AS phone_5, t0.phone_numeric AS phone_numeric_6, t0.privacy_mask AS privacy_mask_7, t0.push_settings_mask AS push_settings_mask_8, t0.publish_daily_count AS publish_daily_count_9, t0.publish_daily_at AS publish_daily_at_10, t0.settings AS settings_11, t0.password AS password_12, t0.about AS about_13, t0.stuff AS stuff_14, t0.vk_code_verifier AS vk_code_verifier_15, t0.vk_id AS vk_id_16, t0.vk_avatar AS vk_avatar_17, t0.new_email AS new_email_18, t0.new_email_token AS new_email_token_19, t0.status AS status_20, t0.role AS role_21, t0.is_online AS is_online_22, t0.last_visit AS last_visit_23, t0.last_visit_at AS last_visit_at_24, t0.confirm_token_token AS confirm_token_token_25, t0.confirm_token_expires AS confirm_token_expires_26, t0.name_first AS name_first_27, t0.name_last AS name_last_28, t0.name_middle AS name_middle_29, t0.avatar_small_hash AS avatar_small_hash_30, t0.avatar_original_hash AS avatar_original_hash_31, t0.reset_token_token AS reset_token_token_32, t0.reset_token_expires AS reset_token_expires_33, t0.city_id AS city_id_34 FROM "user_users" t0 WHERE t0.id = '01945c33-6f15-0e5c-b3f8-b45196ae7e3b';