Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.avatar AS avatar_7,
  t0.job_position AS job_position_8,
  t0.mailbox_view_mode AS mailbox_view_mode_9,
  t0.timezone AS timezone_10,
  t0.created_at AS created_at_11,
  t0.activation_token AS activation_token_12,
  t0.activation_token_expires_at AS activation_token_expires_at_13,
  t0.reset_token AS reset_token_14,
  t0.reset_token_expires_at AS reset_token_expires_at_15,
  t0.is_active AS is_active_16,
  t0.employment_end_date AS employment_end_date_17,
  t0.deactivated_at AS deactivated_at_18,
  t0.notifications_read_at AS notifications_read_at_19,
  t0.dashboard_layout AS dashboard_layout_20,
  t0.last_seen_at AS last_seen_at_21,
  t0.totp_secret AS totp_secret_22,
  t0.totp_enabled AS totp_enabled_23,
  t0.totp_enabled_at AS totp_enabled_at_24,
  t0.sip_extension AS sip_extension_25,
  t0.voip_enabled AS voip_enabled_26,
  t0.can_call_external AS can_call_external_27,
  t0.sip_secret_encrypted AS sip_secret_encrypted_28,
  t0.mailbox_limit AS mailbox_limit_29,
  t0.mail_storage_quota_mb AS mail_storage_quota_mb_30,
  t0.quota_suspended_at AS quota_suspended_at_31,
  t0.quota_locked AS quota_locked_32,
  t0.company_id AS company_id_33
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.avatar AS avatar_7, t0.job_position AS job_position_8, t0.mailbox_view_mode AS mailbox_view_mode_9, t0.timezone AS timezone_10, t0.created_at AS created_at_11, t0.activation_token AS activation_token_12, t0.activation_token_expires_at AS activation_token_expires_at_13, t0.reset_token AS reset_token_14, t0.reset_token_expires_at AS reset_token_expires_at_15, t0.is_active AS is_active_16, t0.employment_end_date AS employment_end_date_17, t0.deactivated_at AS deactivated_at_18, t0.notifications_read_at AS notifications_read_at_19, t0.dashboard_layout AS dashboard_layout_20, t0.last_seen_at AS last_seen_at_21, t0.totp_secret AS totp_secret_22, t0.totp_enabled AS totp_enabled_23, t0.totp_enabled_at AS totp_enabled_at_24, t0.sip_extension AS sip_extension_25, t0.voip_enabled AS voip_enabled_26, t0.can_call_external AS can_call_external_27, t0.sip_secret_encrypted AS sip_secret_encrypted_28, t0.mailbox_limit AS mailbox_limit_29, t0.mail_storage_quota_mb AS mail_storage_quota_mb_30, t0.quota_suspended_at AS quota_suspended_at_31, t0.quota_locked AS quota_locked_32, t0.company_id AS company_id_33 FROM `user` t0 WHERE t0.id = 9;

SELECT
  u0_.id AS id_0,
  u0_.is_default AS is_default_1,
  u0_.platform_role AS platform_role_2,
  u0_.permission_overrides AS permission_overrides_3,
  u0_.created_at AS created_at_4,
  t1_.id AS id_5,
  t1_.name AS name_6,
  t1_.slug AS slug_7,
  t1_.is_active AS is_active_8,
  t1_.is_platform AS is_platform_9,
  t1_.created_at AS created_at_10,
  t1_.user_slots_pool AS user_slots_pool_11,
  t1_.mailbox_slots_pool AS mailbox_slots_pool_12,
  t1_.microsoft_oauth_enabled AS microsoft_oauth_enabled_13,
  t1_.microsoft_oauth_tenant_id AS microsoft_oauth_tenant_id_14,
  t1_.microsoft_oauth_client_id AS microsoft_oauth_client_id_15,
  t1_.microsoft_oauth_client_secret AS microsoft_oauth_client_secret_16,
  t1_.microsoft_oauth_redirect_uri AS microsoft_oauth_redirect_uri_17,
  u0_.user_id AS user_id_18,
  u0_.tenant_id AS tenant_id_19
FROM
  user_tenant u0_
  INNER JOIN tenant t1_ ON u0_.tenant_id = t1_.id
WHERE
  u0_.user_id = ?
  AND t1_.is_active = 1
ORDER BY
  u0_.is_default DESC,
  t1_.name ASC

SELECT u0_.id AS id_0, u0_.is_default AS is_default_1, u0_.platform_role AS platform_role_2, u0_.permission_overrides AS permission_overrides_3, u0_.created_at AS created_at_4, t1_.id AS id_5, t1_.name AS name_6, t1_.slug AS slug_7, t1_.is_active AS is_active_8, t1_.is_platform AS is_platform_9, t1_.created_at AS created_at_10, t1_.user_slots_pool AS user_slots_pool_11, t1_.mailbox_slots_pool AS mailbox_slots_pool_12, t1_.microsoft_oauth_enabled AS microsoft_oauth_enabled_13, t1_.microsoft_oauth_tenant_id AS microsoft_oauth_tenant_id_14, t1_.microsoft_oauth_client_id AS microsoft_oauth_client_id_15, t1_.microsoft_oauth_client_secret AS microsoft_oauth_client_secret_16, t1_.microsoft_oauth_redirect_uri AS microsoft_oauth_redirect_uri_17, u0_.user_id AS user_id_18, u0_.tenant_id AS tenant_id_19 FROM user_tenant u0_ INNER JOIN tenant t1_ ON u0_.tenant_id = t1_.id WHERE u0_.user_id = 9 AND t1_.is_active = 1 ORDER BY u0_.is_default DESC, t1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.platform_role AS platform_role_3,
  t0.permission_overrides AS permission_overrides_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.tenant_id AS tenant_id_7
FROM
  user_tenant t0
WHERE
  t0.user_id = ?
  AND t0.tenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = 9 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.platform_role AS platform_role_3,
  t0.permission_overrides AS permission_overrides_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.tenant_id AS tenant_id_7
FROM
  user_tenant t0
WHERE
  t0.user_id = ?
  AND t0.tenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = 9 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.platform_role AS platform_role_3,
  t0.permission_overrides AS permission_overrides_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.tenant_id AS tenant_id_7
FROM
  user_tenant t0
WHERE
  t0.user_id = ?
  AND t0.tenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = 9 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.platform_role AS platform_role_3,
  t0.permission_overrides AS permission_overrides_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.tenant_id AS tenant_id_7
FROM
  user_tenant t0
WHERE
  t0.user_id = ?
  AND t0.tenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = 9 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.billing_period AS billing_period_2,
  t0_.started_at AS started_at_3,
  t0_.ends_at AS ends_at_4,
  t0_.notes AS notes_5,
  s1_.id AS id_6,
  s1_.name AS name_7,
  s1_.slug AS slug_8,
  s1_.description AS description_9,
  s1_.is_active AS is_active_10,
  s1_.sort_order AS sort_order_11,
  s1_.monthly_price_cents AS monthly_price_cents_12,
  s1_.max_users AS max_users_13,
  s1_.max_widget_sites AS max_widget_sites_14,
  s1_.projects_enabled AS projects_enabled_15,
  s1_.widget_enabled AS widget_enabled_16,
  s1_.voip_enabled AS voip_enabled_17,
  s1_.tickets_enabled AS tickets_enabled_18,
  s1_.internal_chat_enabled AS internal_chat_enabled_19,
  s1_.projects_price_cents AS projects_price_cents_20,
  s1_.widget_price_cents AS widget_price_cents_21,
  s1_.ticket_price_cents AS ticket_price_cents_22,
  s1_.internal_chat_price_cents AS internal_chat_price_cents_23,
  s1_.voip_price_cents AS voip_price_cents_24,
  s1_.billing_discount_percent_3_months AS billing_discount_percent_3_months_25,
  s1_.billing_discount_percent_6_months AS billing_discount_percent_6_months_26,
  s1_.billing_discount_percent_12_months AS billing_discount_percent_12_months_27,
  s1_.created_at AS created_at_28,
  t0_.tenant_id AS tenant_id_29,
  t0_.package_id AS package_id_30
FROM
  tenant_subscription t0_
  INNER JOIN service_package s1_ ON t0_.package_id = s1_.id
WHERE
  t0_.tenant_id = ?
  AND t0_.status = ?
ORDER BY
  t0_.started_at DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.billing_period AS billing_period_2, t0_.started_at AS started_at_3, t0_.ends_at AS ends_at_4, t0_.notes AS notes_5, s1_.id AS id_6, s1_.name AS name_7, s1_.slug AS slug_8, s1_.description AS description_9, s1_.is_active AS is_active_10, s1_.sort_order AS sort_order_11, s1_.monthly_price_cents AS monthly_price_cents_12, s1_.max_users AS max_users_13, s1_.max_widget_sites AS max_widget_sites_14, s1_.projects_enabled AS projects_enabled_15, s1_.widget_enabled AS widget_enabled_16, s1_.voip_enabled AS voip_enabled_17, s1_.tickets_enabled AS tickets_enabled_18, s1_.internal_chat_enabled AS internal_chat_enabled_19, s1_.projects_price_cents AS projects_price_cents_20, s1_.widget_price_cents AS widget_price_cents_21, s1_.ticket_price_cents AS ticket_price_cents_22, s1_.internal_chat_price_cents AS internal_chat_price_cents_23, s1_.voip_price_cents AS voip_price_cents_24, s1_.billing_discount_percent_3_months AS billing_discount_percent_3_months_25, s1_.billing_discount_percent_6_months AS billing_discount_percent_6_months_26, s1_.billing_discount_percent_12_months AS billing_discount_percent_12_months_27, s1_.created_at AS created_at_28, t0_.tenant_id AS tenant_id_29, t0_.package_id AS package_id_30 FROM tenant_subscription t0_ INNER JOIN service_package s1_ ON t0_.package_id = s1_.id WHERE t0_.tenant_id = 3 AND t0_.status = 'active' ORDER BY t0_.started_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.platform_role AS platform_role_3,
  t0.permission_overrides AS permission_overrides_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.tenant_id AS tenant_id_7
FROM
  user_tenant t0
WHERE
  t0.user_id = ?
  AND t0.tenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = 9 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  MAX(c0_.id) AS sclr_0
FROM
  chat_message c0_
  INNER JOIN chat_conversation c1_ ON c0_.conversation_id = c1_.id
  INNER JOIN chat_participant c2_ ON c1_.id = c2_.conversation_id
WHERE
  c1_.tenant_id = ?
  AND c2_.user_id = ?

SELECT MAX(c0_.id) AS sclr_0 FROM chat_message c0_ INNER JOIN chat_conversation c1_ ON c0_.conversation_id = c1_.id INNER JOIN chat_participant c2_ ON c1_.id = c2_.conversation_id WHERE c1_.tenant_id = 3 AND c2_.user_id = 9;

SELECT
  c0_.id AS id_0,
  c0_.body AS body_1,
  c0_.created_at AS created_at_2,
  c0_.edited_at AS edited_at_3,
  c0_.deleted_at AS deleted_at_4,
  c0_.forwarded AS forwarded_5,
  u1_.id AS id_6,
  u1_.email AS email_7,
  u1_.roles AS roles_8,
  u1_.password AS password_9,
  u1_.first_name AS first_name_10,
  u1_.last_name AS last_name_11,
  u1_.avatar AS avatar_12,
  u1_.job_position AS job_position_13,
  u1_.mailbox_view_mode AS mailbox_view_mode_14,
  u1_.timezone AS timezone_15,
  u1_.created_at AS created_at_16,
  u1_.activation_token AS activation_token_17,
  u1_.activation_token_expires_at AS activation_token_expires_at_18,
  u1_.reset_token AS reset_token_19,
  u1_.reset_token_expires_at AS reset_token_expires_at_20,
  u1_.is_active AS is_active_21,
  u1_.employment_end_date AS employment_end_date_22,
  u1_.deactivated_at AS deactivated_at_23,
  u1_.notifications_read_at AS notifications_read_at_24,
  u1_.dashboard_layout AS dashboard_layout_25,
  u1_.last_seen_at AS last_seen_at_26,
  u1_.totp_secret AS totp_secret_27,
  u1_.totp_enabled AS totp_enabled_28,
  u1_.totp_enabled_at AS totp_enabled_at_29,
  u1_.sip_extension AS sip_extension_30,
  u1_.voip_enabled AS voip_enabled_31,
  u1_.can_call_external AS can_call_external_32,
  u1_.sip_secret_encrypted AS sip_secret_encrypted_33,
  u1_.mailbox_limit AS mailbox_limit_34,
  u1_.mail_storage_quota_mb AS mail_storage_quota_mb_35,
  u1_.quota_suspended_at AS quota_suspended_at_36,
  u1_.quota_locked AS quota_locked_37,
  c2_.id AS id_38,
  c2_.type AS type_39,
  c2_.title AS title_40,
  c2_.image AS image_41,
  c2_.direct_key AS direct_key_42,
  c2_.created_at AS created_at_43,
  c2_.updated_at AS updated_at_44,
  c2_.last_message_preview AS last_message_preview_45,
  c2_.last_message_at AS last_message_at_46,
  c0_.conversation_id AS conversation_id_47,
  c0_.sender_id AS sender_id_48,
  c0_.reply_to_id AS reply_to_id_49,
  u1_.company_id AS company_id_50,
  c2_.tenant_id AS tenant_id_51,
  c2_.created_by_id AS created_by_id_52
FROM
  chat_message c0_
  INNER JOIN `user` u1_ ON c0_.sender_id = u1_.id
  INNER JOIN chat_conversation c2_ ON c0_.conversation_id = c2_.id
  INNER JOIN chat_participant c3_ ON c2_.id = c3_.conversation_id
WHERE
  c2_.tenant_id = ?
  AND c3_.user_id = ?
  AND c0_.sender_id <> ?
  AND c0_.id > ?
  AND c0_.id > COALESCE(c3_.last_read_message_id, 0)
ORDER BY
  c0_.id ASC
LIMIT
  15

SELECT c0_.id AS id_0, c0_.body AS body_1, c0_.created_at AS created_at_2, c0_.edited_at AS edited_at_3, c0_.deleted_at AS deleted_at_4, c0_.forwarded AS forwarded_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.first_name AS first_name_10, u1_.last_name AS last_name_11, u1_.avatar AS avatar_12, u1_.job_position AS job_position_13, u1_.mailbox_view_mode AS mailbox_view_mode_14, u1_.timezone AS timezone_15, u1_.created_at AS created_at_16, u1_.activation_token AS activation_token_17, u1_.activation_token_expires_at AS activation_token_expires_at_18, u1_.reset_token AS reset_token_19, u1_.reset_token_expires_at AS reset_token_expires_at_20, u1_.is_active AS is_active_21, u1_.employment_end_date AS employment_end_date_22, u1_.deactivated_at AS deactivated_at_23, u1_.notifications_read_at AS notifications_read_at_24, u1_.dashboard_layout AS dashboard_layout_25, u1_.last_seen_at AS last_seen_at_26, u1_.totp_secret AS totp_secret_27, u1_.totp_enabled AS totp_enabled_28, u1_.totp_enabled_at AS totp_enabled_at_29, u1_.sip_extension AS sip_extension_30, u1_.voip_enabled AS voip_enabled_31, u1_.can_call_external AS can_call_external_32, u1_.sip_secret_encrypted AS sip_secret_encrypted_33, u1_.mailbox_limit AS mailbox_limit_34, u1_.mail_storage_quota_mb AS mail_storage_quota_mb_35, u1_.quota_suspended_at AS quota_suspended_at_36, u1_.quota_locked AS quota_locked_37, c2_.id AS id_38, c2_.type AS type_39, c2_.title AS title_40, c2_.image AS image_41, c2_.direct_key AS direct_key_42, c2_.created_at AS created_at_43, c2_.updated_at AS updated_at_44, c2_.last_message_preview AS last_message_preview_45, c2_.last_message_at AS last_message_at_46, c0_.conversation_id AS conversation_id_47, c0_.sender_id AS sender_id_48, c0_.reply_to_id AS reply_to_id_49, u1_.company_id AS company_id_50, c2_.tenant_id AS tenant_id_51, c2_.created_by_id AS created_by_id_52 FROM chat_message c0_ INNER JOIN `user` u1_ ON c0_.sender_id = u1_.id INNER JOIN chat_conversation c2_ ON c0_.conversation_id = c2_.id INNER JOIN chat_participant c3_ ON c2_.id = c3_.conversation_id WHERE c2_.tenant_id = 3 AND c3_.user_id = 9 AND c0_.sender_id <> 9 AND c0_.id > 1351 AND c0_.id > COALESCE(c3_.last_read_message_id, 0) ORDER BY c0_.id ASC LIMIT 15;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  chat_message c0_
  INNER JOIN chat_conversation c1_ ON c0_.conversation_id = c1_.id
  INNER JOIN chat_participant c2_ ON c1_.id = c2_.conversation_id
WHERE
  c1_.tenant_id = ?
  AND c2_.user_id = ?
  AND c0_.sender_id <> ?
  AND c0_.id > COALESCE(c2_.last_read_message_id, 0)

SELECT COUNT(c0_.id) AS sclr_0 FROM chat_message c0_ INNER JOIN chat_conversation c1_ ON c0_.conversation_id = c1_.id INNER JOIN chat_participant c2_ ON c1_.id = c2_.conversation_id WHERE c1_.tenant_id = 3 AND c2_.user_id = 9 AND c0_.sender_id <> 9 AND c0_.id > COALESCE(c2_.last_read_message_id, 0);