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 = 6;

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 = 6 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 = 6 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 = 6 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 = 6 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 = 6 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 = 6 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.type AS type_1,
  c0_.title AS title_2,
  c0_.image AS image_3,
  c0_.direct_key AS direct_key_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.last_message_preview AS last_message_preview_7,
  c0_.last_message_at AS last_message_at_8,
  c1_.id AS id_9,
  c1_.role AS role_10,
  c1_.joined_at AS joined_at_11,
  c1_.last_read_at AS last_read_at_12,
  c1_.last_read_message_id AS last_read_message_id_13,
  c1_.last_delivered_message_id AS last_delivered_message_id_14,
  u2_.id AS id_15,
  u2_.email AS email_16,
  u2_.roles AS roles_17,
  u2_.password AS password_18,
  u2_.first_name AS first_name_19,
  u2_.last_name AS last_name_20,
  u2_.avatar AS avatar_21,
  u2_.job_position AS job_position_22,
  u2_.mailbox_view_mode AS mailbox_view_mode_23,
  u2_.timezone AS timezone_24,
  u2_.created_at AS created_at_25,
  u2_.activation_token AS activation_token_26,
  u2_.activation_token_expires_at AS activation_token_expires_at_27,
  u2_.reset_token AS reset_token_28,
  u2_.reset_token_expires_at AS reset_token_expires_at_29,
  u2_.is_active AS is_active_30,
  u2_.employment_end_date AS employment_end_date_31,
  u2_.deactivated_at AS deactivated_at_32,
  u2_.notifications_read_at AS notifications_read_at_33,
  u2_.dashboard_layout AS dashboard_layout_34,
  u2_.last_seen_at AS last_seen_at_35,
  u2_.totp_secret AS totp_secret_36,
  u2_.totp_enabled AS totp_enabled_37,
  u2_.totp_enabled_at AS totp_enabled_at_38,
  u2_.sip_extension AS sip_extension_39,
  u2_.voip_enabled AS voip_enabled_40,
  u2_.can_call_external AS can_call_external_41,
  u2_.sip_secret_encrypted AS sip_secret_encrypted_42,
  u2_.mailbox_limit AS mailbox_limit_43,
  u2_.mail_storage_quota_mb AS mail_storage_quota_mb_44,
  u2_.quota_suspended_at AS quota_suspended_at_45,
  u2_.quota_locked AS quota_locked_46,
  c0_.tenant_id AS tenant_id_47,
  c0_.created_by_id AS created_by_id_48,
  c1_.conversation_id AS conversation_id_49,
  c1_.user_id AS user_id_50,
  u2_.company_id AS company_id_51
FROM
  chat_conversation c0_
  INNER JOIN chat_participant c3_ ON c0_.id = c3_.conversation_id
  LEFT JOIN chat_participant c1_ ON c0_.id = c1_.conversation_id
  LEFT JOIN `user` u2_ ON c1_.user_id = u2_.id
WHERE
  c0_.id = ?
  AND c0_.tenant_id = ?
  AND c3_.user_id = ?

SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.title AS title_2, c0_.image AS image_3, c0_.direct_key AS direct_key_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.last_message_preview AS last_message_preview_7, c0_.last_message_at AS last_message_at_8, c1_.id AS id_9, c1_.role AS role_10, c1_.joined_at AS joined_at_11, c1_.last_read_at AS last_read_at_12, c1_.last_read_message_id AS last_read_message_id_13, c1_.last_delivered_message_id AS last_delivered_message_id_14, u2_.id AS id_15, u2_.email AS email_16, u2_.roles AS roles_17, u2_.password AS password_18, u2_.first_name AS first_name_19, u2_.last_name AS last_name_20, u2_.avatar AS avatar_21, u2_.job_position AS job_position_22, u2_.mailbox_view_mode AS mailbox_view_mode_23, u2_.timezone AS timezone_24, u2_.created_at AS created_at_25, u2_.activation_token AS activation_token_26, u2_.activation_token_expires_at AS activation_token_expires_at_27, u2_.reset_token AS reset_token_28, u2_.reset_token_expires_at AS reset_token_expires_at_29, u2_.is_active AS is_active_30, u2_.employment_end_date AS employment_end_date_31, u2_.deactivated_at AS deactivated_at_32, u2_.notifications_read_at AS notifications_read_at_33, u2_.dashboard_layout AS dashboard_layout_34, u2_.last_seen_at AS last_seen_at_35, u2_.totp_secret AS totp_secret_36, u2_.totp_enabled AS totp_enabled_37, u2_.totp_enabled_at AS totp_enabled_at_38, u2_.sip_extension AS sip_extension_39, u2_.voip_enabled AS voip_enabled_40, u2_.can_call_external AS can_call_external_41, u2_.sip_secret_encrypted AS sip_secret_encrypted_42, u2_.mailbox_limit AS mailbox_limit_43, u2_.mail_storage_quota_mb AS mail_storage_quota_mb_44, u2_.quota_suspended_at AS quota_suspended_at_45, u2_.quota_locked AS quota_locked_46, c0_.tenant_id AS tenant_id_47, c0_.created_by_id AS created_by_id_48, c1_.conversation_id AS conversation_id_49, c1_.user_id AS user_id_50, u2_.company_id AS company_id_51 FROM chat_conversation c0_ INNER JOIN chat_participant c3_ ON c0_.id = c3_.conversation_id LEFT JOIN chat_participant c1_ ON c0_.id = c1_.conversation_id LEFT JOIN `user` u2_ ON c1_.user_id = u2_.id WHERE c0_.id = 13 AND c0_.tenant_id = 3 AND c3_.user_id = 6;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.joined_at AS joined_at_3,
  t0.last_read_at AS last_read_at_4,
  t0.last_read_message_id AS last_read_message_id_5,
  t0.last_delivered_message_id AS last_delivered_message_id_6,
  t0.conversation_id AS conversation_id_7,
  t0.user_id AS user_id_8
FROM
  chat_participant t0
WHERE
  t0.conversation_id = ?
  AND t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.role AS role_2, t0.joined_at AS joined_at_3, t0.last_read_at AS last_read_at_4, t0.last_read_message_id AS last_read_message_id_5, t0.last_delivered_message_id AS last_delivered_message_id_6, t0.conversation_id AS conversation_id_7, t0.user_id AS user_id_8 FROM chat_participant t0 WHERE t0.conversation_id = 13 AND t0.user_id = 6 LIMIT 1;

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,
  c0_.conversation_id AS conversation_id_38,
  c0_.sender_id AS sender_id_39,
  c0_.reply_to_id AS reply_to_id_40,
  u1_.company_id AS company_id_41
FROM
  chat_message c0_
  INNER JOIN `user` u1_ ON c0_.sender_id = u1_.id
WHERE
  c0_.conversation_id = ?
ORDER BY
  c0_.id DESC
LIMIT
  80

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, c0_.conversation_id AS conversation_id_38, c0_.sender_id AS sender_id_39, c0_.reply_to_id AS reply_to_id_40, u1_.company_id AS company_id_41 FROM chat_message c0_ INNER JOIN `user` u1_ ON c0_.sender_id = u1_.id WHERE c0_.conversation_id = 13 ORDER BY c0_.id DESC LIMIT 80;

SELECT
  c0_.id AS id_0
FROM
  chat_message c0_
WHERE
  c0_.conversation_id = ?
  AND c0_.id < ?
ORDER BY
  c0_.id DESC
LIMIT
  1

SELECT c0_.id AS id_0 FROM chat_message c0_ WHERE c0_.conversation_id = 13 AND c0_.id < 1036 ORDER BY c0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.joined_at AS joined_at_3,
  t0.last_read_at AS last_read_at_4,
  t0.last_read_message_id AS last_read_message_id_5,
  t0.last_delivered_message_id AS last_delivered_message_id_6,
  t0.conversation_id AS conversation_id_7,
  t0.user_id AS user_id_8
FROM
  chat_participant t0
WHERE
  t0.conversation_id = ?
  AND t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.role AS role_2, t0.joined_at AS joined_at_3, t0.last_read_at AS last_read_at_4, t0.last_read_message_id AS last_read_message_id_5, t0.last_delivered_message_id AS last_delivered_message_id_6, t0.conversation_id AS conversation_id_7, t0.user_id AS user_id_8 FROM chat_participant t0 WHERE t0.conversation_id = 13 AND t0.user_id = 6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1036 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1037 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1038 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1039 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1040 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1041 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1053 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1057 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1059 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1060 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.message_id AS message_id_8
FROM
  chat_message_attachment t0
WHERE
  t0.message_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.message_id AS message_id_8 FROM chat_message_attachment t0 WHERE t0.message_id = 1061 ORDER BY t0.id ASC;