Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

26 Database Queries

20 Different statements

3.68 ms Query time

0 Invalid entities

121 Managed entities

Queries

Group similar statements


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 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 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 = ? 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 = ? AND t0.tenant_id = ? LIMIT 1
SELECT u0_.notification_key AS notification_key_0 FROM user_notification_read u0_ WHERE u0_.user_id = ?
SELECT u0_.id AS id_0, u0_.access_permission AS access_permission_1, u0_.label AS label_2, u0_.email AS email_3, u0_.incoming_protocol AS incoming_protocol_4, u0_.incoming_host AS incoming_host_5, u0_.incoming_port AS incoming_port_6, u0_.incoming_encryption AS incoming_encryption_7, u0_.incoming_username AS incoming_username_8, u0_.incoming_password AS incoming_password_9, u0_.smtp_host AS smtp_host_10, u0_.smtp_port AS smtp_port_11, u0_.smtp_encryption AS smtp_encryption_12, u0_.smtp_username AS smtp_username_13, u0_.smtp_password AS smtp_password_14, u0_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_15, u0_.is_default AS is_default_16, u0_.is_active AS is_active_17, u0_.quota_suspended_at AS quota_suspended_at_18, u0_.is_shared_access AS is_shared_access_19, u0_.last_tested_at AS last_tested_at_20, u0_.last_test_status AS last_test_status_21, u0_.last_test_message AS last_test_message_22, u0_.auth_provider AS auth_provider_23, u0_.oauth_access_token AS oauth_access_token_24, u0_.oauth_refresh_token AS oauth_refresh_token_25, u0_.oauth_expires_at AS oauth_expires_at_26, u0_.oauth_account_id AS oauth_account_id_27, u0_.signature_html AS signature_html_28, u0_.signature_enabled AS signature_enabled_29, u0_.inbox_sync_high_watermark AS inbox_sync_high_watermark_30, u0_.inbox_uid_validity AS inbox_uid_validity_31, u0_.created_at AS created_at_32, u0_.updated_at AS updated_at_33, u0_.user_id AS user_id_34, u0_.platform_mailbox_id AS platform_mailbox_id_35, u0_.sync_source_mailbox_id AS sync_source_mailbox_id_36, u0_.tenant_id AS tenant_id_37 FROM user_mailbox u0_ WHERE u0_.user_id = ? AND u0_.tenant_id = ? ORDER BY u0_.is_default DESC, u0_.label ASC
SELECT i0_.id AS id_0, i0_.imap_uid AS imap_uid_1, i0_.graph_message_id AS graph_message_id_2, i0_.from_address AS from_address_3, i0_.to_addresses AS to_addresses_4, i0_.cc_addresses AS cc_addresses_5, i0_.reply_to AS reply_to_6, i0_.subject AS subject_7, i0_.body_html AS body_html_8, i0_.body_text AS body_text_9, i0_.preview AS preview_10, i0_.message_id AS message_id_11, i0_.in_reply_to AS in_reply_to_12, i0_.references_json AS references_json_13, i0_.mailed_by AS mailed_by_14, i0_.signed_by AS signed_by_15, i0_.security AS security_16, i0_.seen AS seen_17, i0_.has_server_attachments AS has_server_attachments_18, i0_.received_at AS received_at_19, i0_.synced_at AS synced_at_20, u1_.id AS id_21, u1_.access_permission AS access_permission_22, u1_.label AS label_23, u1_.email AS email_24, u1_.incoming_protocol AS incoming_protocol_25, u1_.incoming_host AS incoming_host_26, u1_.incoming_port AS incoming_port_27, u1_.incoming_encryption AS incoming_encryption_28, u1_.incoming_username AS incoming_username_29, u1_.incoming_password AS incoming_password_30, u1_.smtp_host AS smtp_host_31, u1_.smtp_port AS smtp_port_32, u1_.smtp_encryption AS smtp_encryption_33, u1_.smtp_username AS smtp_username_34, u1_.smtp_password AS smtp_password_35, u1_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_36, u1_.is_default AS is_default_37, u1_.is_active AS is_active_38, u1_.quota_suspended_at AS quota_suspended_at_39, u1_.is_shared_access AS is_shared_access_40, u1_.last_tested_at AS last_tested_at_41, u1_.last_test_status AS last_test_status_42, u1_.last_test_message AS last_test_message_43, u1_.auth_provider AS auth_provider_44, u1_.oauth_access_token AS oauth_access_token_45, u1_.oauth_refresh_token AS oauth_refresh_token_46, u1_.oauth_expires_at AS oauth_expires_at_47, u1_.oauth_account_id AS oauth_account_id_48, u1_.signature_html AS signature_html_49, u1_.signature_enabled AS signature_enabled_50, u1_.inbox_sync_high_watermark AS inbox_sync_high_watermark_51, u1_.inbox_uid_validity AS inbox_uid_validity_52, u1_.created_at AS created_at_53, u1_.updated_at AS updated_at_54, i0_.user_id AS user_id_55, i0_.mailbox_id AS mailbox_id_56, i0_.tenant_id AS tenant_id_57, u1_.user_id AS user_id_58, u1_.platform_mailbox_id AS platform_mailbox_id_59, u1_.sync_source_mailbox_id AS sync_source_mailbox_id_60, u1_.tenant_id AS tenant_id_61 FROM inbox_mail i0_ LEFT JOIN user_mailbox u1_ ON i0_.mailbox_id = u1_.id WHERE i0_.user_id = ? AND i0_.received_at > ? AND i0_.seen = 0 AND i0_.mailbox_id = ? AND i0_.tenant_id = ? ORDER BY i0_.received_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.access_permission AS access_permission_2, t0.label AS label_3, t0.email AS email_4, t0.incoming_protocol AS incoming_protocol_5, t0.incoming_host AS incoming_host_6, t0.incoming_port AS incoming_port_7, t0.incoming_encryption AS incoming_encryption_8, t0.incoming_username AS incoming_username_9, t0.incoming_password AS incoming_password_10, t0.smtp_host AS smtp_host_11, t0.smtp_port AS smtp_port_12, t0.smtp_encryption AS smtp_encryption_13, t0.smtp_username AS smtp_username_14, t0.smtp_password AS smtp_password_15, t0.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_16, t0.is_default AS is_default_17, t0.is_active AS is_active_18, t0.quota_suspended_at AS quota_suspended_at_19, t0.is_shared_access AS is_shared_access_20, t0.last_tested_at AS last_tested_at_21, t0.last_test_status AS last_test_status_22, t0.last_test_message AS last_test_message_23, t0.auth_provider AS auth_provider_24, t0.oauth_access_token AS oauth_access_token_25, t0.oauth_refresh_token AS oauth_refresh_token_26, t0.oauth_expires_at AS oauth_expires_at_27, t0.oauth_account_id AS oauth_account_id_28, t0.signature_html AS signature_html_29, t0.signature_enabled AS signature_enabled_30, t0.inbox_sync_high_watermark AS inbox_sync_high_watermark_31, t0.inbox_uid_validity AS inbox_uid_validity_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.user_id AS user_id_35, t0.platform_mailbox_id AS platform_mailbox_id_36, t0.sync_source_mailbox_id AS sync_source_mailbox_id_37, t0.tenant_id AS tenant_id_38 FROM user_mailbox t0 WHERE t0.id = ?
SELECT i0_.id AS id_0, i0_.imap_uid AS imap_uid_1, i0_.graph_message_id AS graph_message_id_2, i0_.from_address AS from_address_3, i0_.to_addresses AS to_addresses_4, i0_.cc_addresses AS cc_addresses_5, i0_.reply_to AS reply_to_6, i0_.subject AS subject_7, i0_.body_html AS body_html_8, i0_.body_text AS body_text_9, i0_.preview AS preview_10, i0_.message_id AS message_id_11, i0_.in_reply_to AS in_reply_to_12, i0_.references_json AS references_json_13, i0_.mailed_by AS mailed_by_14, i0_.signed_by AS signed_by_15, i0_.security AS security_16, i0_.seen AS seen_17, i0_.has_server_attachments AS has_server_attachments_18, i0_.received_at AS received_at_19, i0_.synced_at AS synced_at_20, u1_.id AS id_21, u1_.access_permission AS access_permission_22, u1_.label AS label_23, u1_.email AS email_24, u1_.incoming_protocol AS incoming_protocol_25, u1_.incoming_host AS incoming_host_26, u1_.incoming_port AS incoming_port_27, u1_.incoming_encryption AS incoming_encryption_28, u1_.incoming_username AS incoming_username_29, u1_.incoming_password AS incoming_password_30, u1_.smtp_host AS smtp_host_31, u1_.smtp_port AS smtp_port_32, u1_.smtp_encryption AS smtp_encryption_33, u1_.smtp_username AS smtp_username_34, u1_.smtp_password AS smtp_password_35, u1_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_36, u1_.is_default AS is_default_37, u1_.is_active AS is_active_38, u1_.quota_suspended_at AS quota_suspended_at_39, u1_.is_shared_access AS is_shared_access_40, u1_.last_tested_at AS last_tested_at_41, u1_.last_test_status AS last_test_status_42, u1_.last_test_message AS last_test_message_43, u1_.auth_provider AS auth_provider_44, u1_.oauth_access_token AS oauth_access_token_45, u1_.oauth_refresh_token AS oauth_refresh_token_46, u1_.oauth_expires_at AS oauth_expires_at_47, u1_.oauth_account_id AS oauth_account_id_48, u1_.signature_html AS signature_html_49, u1_.signature_enabled AS signature_enabled_50, u1_.inbox_sync_high_watermark AS inbox_sync_high_watermark_51, u1_.inbox_uid_validity AS inbox_uid_validity_52, u1_.created_at AS created_at_53, u1_.updated_at AS updated_at_54, i0_.user_id AS user_id_55, i0_.mailbox_id AS mailbox_id_56, i0_.tenant_id AS tenant_id_57, u1_.user_id AS user_id_58, u1_.platform_mailbox_id AS platform_mailbox_id_59, u1_.sync_source_mailbox_id AS sync_source_mailbox_id_60, u1_.tenant_id AS tenant_id_61 FROM inbox_mail i0_ LEFT JOIN user_mailbox u1_ ON i0_.mailbox_id = u1_.id LEFT JOIN inbox_mail_user_read i2_ ON (i2_.inbox_mail_id = i0_.id AND i2_.user_id = ?) WHERE i0_.user_id = ? AND i0_.received_at > ? AND i2_.id IS NULL AND i0_.mailbox_id = ? AND i0_.tenant_id = ? ORDER BY i0_.received_at DESC LIMIT 100
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.due_date AS due_date_5, t0_.start_date AS start_date_6, t0_.status AS status_7, t0_.position AS position_8, t0_.progress AS progress_9, p1_.id AS id_10, p1_.title AS title_11, p1_.description AS description_12, p1_.color AS color_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.due_date AS due_date_16, p1_.status AS status_17, t0_.project_id AS project_id_18, t0_.parent_id AS parent_id_19, t0_.tenant_id AS tenant_id_20, p1_.owner_id AS owner_id_21, p1_.parent_id AS parent_id_22, p1_.tenant_id AS tenant_id_23 FROM task t0_ INNER JOIN task_assignee t3_ ON t0_.id = t3_.task_id INNER JOIN `user` u2_ ON u2_.id = t3_.user_id INNER JOIN project p1_ ON t0_.project_id = p1_.id WHERE t0_.tenant_id = ? AND u2_.id = ? AND ((t0_.updated_at IS NOT NULL AND t0_.updated_at > ?) OR (t0_.updated_at IS NULL AND t0_.created_at > ?)) ORDER BY t0_.updated_at DESC, t0_.created_at DESC LIMIT 100
SELECT t0_.id AS id_0, t0_.invited_email AS invited_email_1, t0_.token AS token_2, t0_.status AS status_3, t0_.created_at AS created_at_4, t0_.accepted_at AS accepted_at_5, t0_.expires_at AS expires_at_6, t1_.id AS id_7, t1_.title AS title_8, t1_.description AS description_9, t1_.created_at AS created_at_10, t1_.updated_at AS updated_at_11, t1_.due_date AS due_date_12, t1_.start_date AS start_date_13, t1_.status AS status_14, t1_.position AS position_15, t1_.progress AS progress_16, p2_.id AS id_17, p2_.title AS title_18, p2_.description AS description_19, p2_.color AS color_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, p2_.due_date AS due_date_23, p2_.status AS status_24, t0_.task_id AS task_id_25, t0_.invited_user_id AS invited_user_id_26, t0_.invited_by_id AS invited_by_id_27, t1_.project_id AS project_id_28, t1_.parent_id AS parent_id_29, t1_.tenant_id AS tenant_id_30, p2_.owner_id AS owner_id_31, p2_.parent_id AS parent_id_32, p2_.tenant_id AS tenant_id_33 FROM task_invitation t0_ INNER JOIN task t1_ ON t0_.task_id = t1_.id INNER JOIN project p2_ ON t1_.project_id = p2_.id WHERE t0_.status = ? AND t0_.created_at > ? AND (t0_.invited_user_id = ? OR t0_.invited_email = ?) AND p2_.tenant_id = ? ORDER BY t0_.created_at DESC LIMIT 100
SELECT t0_.assigned_at AS assigned_at_0, t1_.id AS id_1, t1_.code AS code_2, t1_.subject AS subject_3, t1_.description AS description_4, t1_.status AS status_5, t1_.priority AS priority_6, t1_.issue_type AS issue_type_7, t1_.category AS category_8, t1_.portal_token AS portal_token_9, t1_.source AS source_10, t1_.due_date AS due_date_11, t1_.resolved_at AS resolved_at_12, t1_.closed_at AS closed_at_13, t1_.created_at AS created_at_14, t1_.updated_at AS updated_at_15, t1_.last_customer_seen_at AS last_customer_seen_at_16, t1_.customer_satisfaction AS customer_satisfaction_17, t1_.customer_feedback_comment AS customer_feedback_comment_18, t1_.customer_feedback_at AS customer_feedback_at_19, t1_.customer_close_reason AS customer_close_reason_20, t1_.template_name_snapshot AS template_name_snapshot_21, c2_.id AS id_22, c2_.first_name AS first_name_23, c2_.last_name AS last_name_24, c2_.email AS email_25, c2_.password AS password_26, c2_.phone AS phone_27, c2_.job_title AS job_title_28, c2_.company_name AS company_name_29, c2_.notes AS notes_30, c2_.is_active AS is_active_31, c2_.email_notifications AS email_notifications_32, c2_.created_at AS created_at_33, c2_.updated_at AS updated_at_34, c2_.sip_extension AS sip_extension_35, c2_.voip_enabled AS voip_enabled_36, c2_.sip_secret_encrypted AS sip_secret_encrypted_37, t0_.ticket_id AS ticket_id_38, t0_.user_id AS user_id_39, t1_.requester_id AS requester_id_40, t1_.company_id AS company_id_41, t1_.current_support_level_id AS current_support_level_id_42, t1_.project_id AS project_id_43, t1_.customer_id AS customer_id_44, t1_.supplier_id AS supplier_id_45, t1_.catalog_product_id AS catalog_product_id_46, t1_.widget_site_id AS widget_site_id_47, t1_.updated_by_id AS updated_by_id_48, t1_.updated_by_customer_id AS updated_by_customer_id_49, t1_.updated_by_supplier_id AS updated_by_supplier_id_50, t1_.tenant_id AS tenant_id_51, t1_.source_tenant_id AS source_tenant_id_52, t1_.ticket_template_id AS ticket_template_id_53, c2_.company_id AS company_id_54, c2_.service_company_id AS service_company_id_55, c2_.created_by_id AS created_by_id_56, c2_.tenant_id AS tenant_id_57 FROM ticket_assignee t0_ INNER JOIN ticket t1_ ON t0_.ticket_id = t1_.id LEFT JOIN customer c2_ ON t1_.customer_id = c2_.id WHERE t0_.user_id = ? AND t0_.assigned_at >= ? ORDER BY t0_.assigned_at DESC LIMIT 100
SELECT DISTINCT t0_.id AS id_0, t0_.code AS code_1, t0_.subject AS subject_2, t0_.description AS description_3, t0_.status AS status_4, t0_.priority AS priority_5, t0_.issue_type AS issue_type_6, t0_.category AS category_7, t0_.portal_token AS portal_token_8, t0_.source AS source_9, t0_.due_date AS due_date_10, t0_.resolved_at AS resolved_at_11, t0_.closed_at AS closed_at_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.last_customer_seen_at AS last_customer_seen_at_15, t0_.customer_satisfaction AS customer_satisfaction_16, t0_.customer_feedback_comment AS customer_feedback_comment_17, t0_.customer_feedback_at AS customer_feedback_at_18, t0_.customer_close_reason AS customer_close_reason_19, t0_.template_name_snapshot AS template_name_snapshot_20, c1_.id AS id_21, c1_.first_name AS first_name_22, c1_.last_name AS last_name_23, c1_.email AS email_24, c1_.password AS password_25, c1_.phone AS phone_26, c1_.job_title AS job_title_27, c1_.company_name AS company_name_28, c1_.notes AS notes_29, c1_.is_active AS is_active_30, c1_.email_notifications AS email_notifications_31, c1_.created_at AS created_at_32, c1_.updated_at AS updated_at_33, c1_.sip_extension AS sip_extension_34, c1_.voip_enabled AS voip_enabled_35, c1_.sip_secret_encrypted AS sip_secret_encrypted_36, t0_.requester_id AS requester_id_37, t0_.company_id AS company_id_38, t0_.current_support_level_id AS current_support_level_id_39, t0_.project_id AS project_id_40, t0_.customer_id AS customer_id_41, t0_.supplier_id AS supplier_id_42, t0_.catalog_product_id AS catalog_product_id_43, t0_.widget_site_id AS widget_site_id_44, t0_.updated_by_id AS updated_by_id_45, t0_.updated_by_customer_id AS updated_by_customer_id_46, t0_.updated_by_supplier_id AS updated_by_supplier_id_47, t0_.tenant_id AS tenant_id_48, t0_.source_tenant_id AS source_tenant_id_49, t0_.ticket_template_id AS ticket_template_id_50, c1_.company_id AS company_id_51, c1_.service_company_id AS service_company_id_52, c1_.created_by_id AS created_by_id_53, c1_.tenant_id AS tenant_id_54 FROM ticket t0_ LEFT JOIN ticket_assignee t2_ ON t0_.id = t2_.ticket_id LEFT JOIN ticket_user_read t3_ ON (t3_.ticket_id = t0_.id AND t3_.user_id = ?) LEFT JOIN customer c1_ ON t0_.customer_id = c1_.id WHERE t0_.updated_at IS NOT NULL AND t0_.updated_at >= ? AND t0_.updated_at > t0_.created_at AND ((t2_.user_id = ? OR t0_.requester_id = ?)) AND ((t3_.id IS NULL OR t3_.last_read_at < t0_.updated_at)) AND t0_.tenant_id = ? ORDER BY t0_.updated_at DESC LIMIT 100
SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC
SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC
SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC
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.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.location AS location_3, c0_.ics_uid AS ics_uid_4, c0_.starts_at AS starts_at_5, c0_.ends_at AS ends_at_6, c0_.all_day AS all_day_7, c0_.color AS color_8, c0_.alarm_minutes_before AS alarm_minutes_before_9, c0_.alarm_sent_at AS alarm_sent_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.user_id AS user_id_13 FROM calendar_event c0_ WHERE (c0_.user_id = ? OR EXISTS (SELECT 1 FROM calendar_event_share c1_ WHERE c1_.calendar_event_id = c0_.id AND c1_.user_id IN (?))) AND c0_.alarm_sent_at IS NOT NULL AND c0_.alarm_sent_at >= ? ORDER BY c0_.alarm_sent_at DESC LIMIT 50
SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.status AS status_2, h0_.expected_end_at AS expected_end_at_3, h0_.proposed_clock_out_at AS proposed_clock_out_at_4, h0_.reminder_sent_at AS reminder_sent_at_5, h0_.anomaly_detected_at AS anomaly_detected_at_6, h0_.confirmed_at AS confirmed_at_7, h0_.resolved_at AS resolved_at_8, h0_.notes AS notes_9, h0_.created_at AS created_at_10, h0_.updated_at AS updated_at_11, h0_.tenant_id AS tenant_id_12, h0_.user_id AS user_id_13 FROM hr_day_closure_proposal h0_ WHERE h0_.user_id = ? AND h0_.status IN (?, ?) AND ((h0_.reminder_sent_at IS NOT NULL AND h0_.reminder_sent_at >= ?) OR (h0_.anomaly_detected_at IS NOT NULL AND h0_.anomaly_detected_at >= ?)) ORDER BY h0_.updated_at DESC LIMIT 50
SELECT h0_.id AS id_0, h0_.type AS type_1, h0_.duration AS duration_2, h0_.start_date AS start_date_3, h0_.end_date AS end_date_4, h0_.hours_minutes AS hours_minutes_5, h0_.start_time AS start_time_6, h0_.end_time AS end_time_7, h0_.status AS status_8, h0_.reason AS reason_9, h0_.decided_at AS decided_at_10, h0_.decision_note AS decision_note_11, h0_.cancellation_reason AS cancellation_reason_12, h0_.cancellation_requested_at AS cancellation_requested_at_13, h0_.created_at AS created_at_14, h0_.updated_at AS updated_at_15, h0_.tenant_id AS tenant_id_16, h0_.user_id AS user_id_17, h0_.decided_by_id AS decided_by_id_18 FROM hr_leave_request h0_ WHERE h0_.user_id = ? AND h0_.status IN (?, ?) AND h0_.decided_at IS NOT NULL AND h0_.decided_at >= ? ORDER BY h0_.decided_at DESC LIMIT 50
SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.minutes AS minutes_2, h0_.expected_minutes AS expected_minutes_3, h0_.worked_minutes AS worked_minutes_4, h0_.status AS status_5, h0_.decided_at AS decided_at_6, h0_.decision_note AS decision_note_7, h0_.created_at AS created_at_8, h0_.updated_at AS updated_at_9, h0_.tenant_id AS tenant_id_10, h0_.user_id AS user_id_11, h0_.decided_by_id AS decided_by_id_12 FROM hr_overtime_record h0_ WHERE h0_.user_id = ? AND h0_.status IN (?, ?) AND h0_.decided_at IS NOT NULL AND h0_.decided_at >= ? ORDER BY h0_.decided_at DESC LIMIT 50
SELECT l0_.id AS id_0, l0_.kind AS kind_1, l0_.first_name AS first_name_2, l0_.last_name AS last_name_3, l0_.company_name AS company_name_4, l0_.tax_code AS tax_code_5, l0_.vat_number AS vat_number_6, l0_.contact_person AS contact_person_7, l0_.phone AS phone_8, l0_.phone_secondary AS phone_secondary_9, l0_.email AS email_10, l0_.pec AS pec_11, l0_.website AS website_12, l0_.other_contacts AS other_contacts_13, l0_.business_category AS business_category_14, l0_.business_type AS business_type_15, l0_.local_units_count AS local_units_count_16, l0_.business_notes AS business_notes_17, l0_.interest_product AS interest_product_18, l0_.potential_products AS potential_products_19, l0_.priority AS priority_20, l0_.notes AS notes_21, l0_.next_action_at AS next_action_at_22, l0_.next_action_label AS next_action_label_23, l0_.last_activity_at AS last_activity_at_24, l0_.converted_at AS converted_at_25, l0_.is_archived AS is_archived_26, l0_.created_at AS created_at_27, l0_.updated_at AS updated_at_28, l0_.tenant_id AS tenant_id_29, l0_.source_id AS source_id_30, l0_.status_id AS status_id_31, l0_.assigned_group_id AS assigned_group_id_32, l0_.assigned_to_id AS assigned_to_id_33, l0_.converted_customer_id AS converted_customer_id_34, l0_.converted_user_id AS converted_user_id_35, l0_.created_by_id AS created_by_id_36 FROM lead l0_ WHERE l0_.is_archived = 0 AND l0_.assigned_to_id = ? AND l0_.next_action_at IS NOT NULL AND l0_.next_action_at < ? AND (l0_.updated_at >= ? OR l0_.next_action_at >= ?) AND l0_.tenant_id = ? ORDER BY l0_.next_action_at ASC LIMIT 100
SELECT l0_.id AS id_0, l0_.kind AS kind_1, l0_.first_name AS first_name_2, l0_.last_name AS last_name_3, l0_.company_name AS company_name_4, l0_.tax_code AS tax_code_5, l0_.vat_number AS vat_number_6, l0_.contact_person AS contact_person_7, l0_.phone AS phone_8, l0_.phone_secondary AS phone_secondary_9, l0_.email AS email_10, l0_.pec AS pec_11, l0_.website AS website_12, l0_.other_contacts AS other_contacts_13, l0_.business_category AS business_category_14, l0_.business_type AS business_type_15, l0_.local_units_count AS local_units_count_16, l0_.business_notes AS business_notes_17, l0_.interest_product AS interest_product_18, l0_.potential_products AS potential_products_19, l0_.priority AS priority_20, l0_.notes AS notes_21, l0_.next_action_at AS next_action_at_22, l0_.next_action_label AS next_action_label_23, l0_.last_activity_at AS last_activity_at_24, l0_.converted_at AS converted_at_25, l0_.is_archived AS is_archived_26, l0_.created_at AS created_at_27, l0_.updated_at AS updated_at_28, l0_.tenant_id AS tenant_id_29, l0_.source_id AS source_id_30, l0_.status_id AS status_id_31, l0_.assigned_group_id AS assigned_group_id_32, l0_.assigned_to_id AS assigned_to_id_33, l0_.converted_customer_id AS converted_customer_id_34, l0_.converted_user_id AS converted_user_id_35, l0_.created_by_id AS created_by_id_36 FROM lead l0_ WHERE l0_.is_archived = 0 AND l0_.assigned_to_id = ? AND (l0_.updated_at >= ? OR l0_.created_at >= ?) AND l0_.tenant_id = ? ORDER BY l0_.updated_at DESC LIMIT 100
SELECT m0_.id AS id_0, m0_.source_type AS source_type_1, m0_.source_id AS source_id_2, m0_.context_type AS context_type_3, m0_.context_id AS context_id_4, m0_.excerpt AS excerpt_5, m0_.created_at AS created_at_6, m0_.mentioned_user_id AS mentioned_user_id_7, m0_.created_by_id AS created_by_id_8 FROM mention m0_ WHERE m0_.mentioned_user_id = ? AND m0_.created_at >= ? AND (m0_.created_by_id IS NULL OR m0_.created_by_id <> ?) ORDER BY m0_.created_at DESC, m0_.id DESC LIMIT 100

#▲	Time	Info
1	0.12 ms	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 = ? Parameters: [`9`] View formatted query View runnable query Explain query 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;
2	0.03 ms	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 Parameters: [`9`] View formatted query View runnable query Explain query 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;
3	0.02 ms	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 Parameters: [`9 3`] View formatted query View runnable query Explain query 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;
4	0.02 ms	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 Parameters: [`9 3`] View formatted query View runnable query Explain query 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;
5	0.01 ms	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 Parameters: [`9 3`] View formatted query View runnable query Explain query 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;
6	0.04 ms	SELECT u0_.notification_key AS notification_key_0 FROM user_notification_read u0_ WHERE u0_.user_id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT u0_.notification_key AS notification_key_0 FROM user_notification_read u0_ WHERE u0_.user_id = ? SELECT u0_.notification_key AS notification_key_0 FROM user_notification_read u0_ WHERE u0_.user_id = 9;
7	0.04 ms	SELECT u0_.id AS id_0, u0_.access_permission AS access_permission_1, u0_.label AS label_2, u0_.email AS email_3, u0_.incoming_protocol AS incoming_protocol_4, u0_.incoming_host AS incoming_host_5, u0_.incoming_port AS incoming_port_6, u0_.incoming_encryption AS incoming_encryption_7, u0_.incoming_username AS incoming_username_8, u0_.incoming_password AS incoming_password_9, u0_.smtp_host AS smtp_host_10, u0_.smtp_port AS smtp_port_11, u0_.smtp_encryption AS smtp_encryption_12, u0_.smtp_username AS smtp_username_13, u0_.smtp_password AS smtp_password_14, u0_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_15, u0_.is_default AS is_default_16, u0_.is_active AS is_active_17, u0_.quota_suspended_at AS quota_suspended_at_18, u0_.is_shared_access AS is_shared_access_19, u0_.last_tested_at AS last_tested_at_20, u0_.last_test_status AS last_test_status_21, u0_.last_test_message AS last_test_message_22, u0_.auth_provider AS auth_provider_23, u0_.oauth_access_token AS oauth_access_token_24, u0_.oauth_refresh_token AS oauth_refresh_token_25, u0_.oauth_expires_at AS oauth_expires_at_26, u0_.oauth_account_id AS oauth_account_id_27, u0_.signature_html AS signature_html_28, u0_.signature_enabled AS signature_enabled_29, u0_.inbox_sync_high_watermark AS inbox_sync_high_watermark_30, u0_.inbox_uid_validity AS inbox_uid_validity_31, u0_.created_at AS created_at_32, u0_.updated_at AS updated_at_33, u0_.user_id AS user_id_34, u0_.platform_mailbox_id AS platform_mailbox_id_35, u0_.sync_source_mailbox_id AS sync_source_mailbox_id_36, u0_.tenant_id AS tenant_id_37 FROM user_mailbox u0_ WHERE u0_.user_id = ? AND u0_.tenant_id = ? ORDER BY u0_.is_default DESC, u0_.label ASC Parameters: [`9 3`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.access_permission AS access_permission_1, u0_.label AS label_2, u0_.email AS email_3, u0_.incoming_protocol AS incoming_protocol_4, u0_.incoming_host AS incoming_host_5, u0_.incoming_port AS incoming_port_6, u0_.incoming_encryption AS incoming_encryption_7, u0_.incoming_username AS incoming_username_8, u0_.incoming_password AS incoming_password_9, u0_.smtp_host AS smtp_host_10, u0_.smtp_port AS smtp_port_11, u0_.smtp_encryption AS smtp_encryption_12, u0_.smtp_username AS smtp_username_13, u0_.smtp_password AS smtp_password_14, u0_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_15, u0_.is_default AS is_default_16, u0_.is_active AS is_active_17, u0_.quota_suspended_at AS quota_suspended_at_18, u0_.is_shared_access AS is_shared_access_19, u0_.last_tested_at AS last_tested_at_20, u0_.last_test_status AS last_test_status_21, u0_.last_test_message AS last_test_message_22, u0_.auth_provider AS auth_provider_23, u0_.oauth_access_token AS oauth_access_token_24, u0_.oauth_refresh_token AS oauth_refresh_token_25, u0_.oauth_expires_at AS oauth_expires_at_26, u0_.oauth_account_id AS oauth_account_id_27, u0_.signature_html AS signature_html_28, u0_.signature_enabled AS signature_enabled_29, u0_.inbox_sync_high_watermark AS inbox_sync_high_watermark_30, u0_.inbox_uid_validity AS inbox_uid_validity_31, u0_.created_at AS created_at_32, u0_.updated_at AS updated_at_33, u0_.user_id AS user_id_34, u0_.platform_mailbox_id AS platform_mailbox_id_35, u0_.sync_source_mailbox_id AS sync_source_mailbox_id_36, u0_.tenant_id AS tenant_id_37 FROM user_mailbox u0_ WHERE u0_.user_id = ? AND u0_.tenant_id = ? ORDER BY u0_.is_default DESC, u0_.label ASC SELECT u0_.id AS id_0, u0_.access_permission AS access_permission_1, u0_.label AS label_2, u0_.email AS email_3, u0_.incoming_protocol AS incoming_protocol_4, u0_.incoming_host AS incoming_host_5, u0_.incoming_port AS incoming_port_6, u0_.incoming_encryption AS incoming_encryption_7, u0_.incoming_username AS incoming_username_8, u0_.incoming_password AS incoming_password_9, u0_.smtp_host AS smtp_host_10, u0_.smtp_port AS smtp_port_11, u0_.smtp_encryption AS smtp_encryption_12, u0_.smtp_username AS smtp_username_13, u0_.smtp_password AS smtp_password_14, u0_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_15, u0_.is_default AS is_default_16, u0_.is_active AS is_active_17, u0_.quota_suspended_at AS quota_suspended_at_18, u0_.is_shared_access AS is_shared_access_19, u0_.last_tested_at AS last_tested_at_20, u0_.last_test_status AS last_test_status_21, u0_.last_test_message AS last_test_message_22, u0_.auth_provider AS auth_provider_23, u0_.oauth_access_token AS oauth_access_token_24, u0_.oauth_refresh_token AS oauth_refresh_token_25, u0_.oauth_expires_at AS oauth_expires_at_26, u0_.oauth_account_id AS oauth_account_id_27, u0_.signature_html AS signature_html_28, u0_.signature_enabled AS signature_enabled_29, u0_.inbox_sync_high_watermark AS inbox_sync_high_watermark_30, u0_.inbox_uid_validity AS inbox_uid_validity_31, u0_.created_at AS created_at_32, u0_.updated_at AS updated_at_33, u0_.user_id AS user_id_34, u0_.platform_mailbox_id AS platform_mailbox_id_35, u0_.sync_source_mailbox_id AS sync_source_mailbox_id_36, u0_.tenant_id AS tenant_id_37 FROM user_mailbox u0_ WHERE u0_.user_id = 9 AND u0_.tenant_id = 3 ORDER BY u0_.is_default DESC, u0_.label ASC;
8	0.32 ms	SELECT i0_.id AS id_0, i0_.imap_uid AS imap_uid_1, i0_.graph_message_id AS graph_message_id_2, i0_.from_address AS from_address_3, i0_.to_addresses AS to_addresses_4, i0_.cc_addresses AS cc_addresses_5, i0_.reply_to AS reply_to_6, i0_.subject AS subject_7, i0_.body_html AS body_html_8, i0_.body_text AS body_text_9, i0_.preview AS preview_10, i0_.message_id AS message_id_11, i0_.in_reply_to AS in_reply_to_12, i0_.references_json AS references_json_13, i0_.mailed_by AS mailed_by_14, i0_.signed_by AS signed_by_15, i0_.security AS security_16, i0_.seen AS seen_17, i0_.has_server_attachments AS has_server_attachments_18, i0_.received_at AS received_at_19, i0_.synced_at AS synced_at_20, u1_.id AS id_21, u1_.access_permission AS access_permission_22, u1_.label AS label_23, u1_.email AS email_24, u1_.incoming_protocol AS incoming_protocol_25, u1_.incoming_host AS incoming_host_26, u1_.incoming_port AS incoming_port_27, u1_.incoming_encryption AS incoming_encryption_28, u1_.incoming_username AS incoming_username_29, u1_.incoming_password AS incoming_password_30, u1_.smtp_host AS smtp_host_31, u1_.smtp_port AS smtp_port_32, u1_.smtp_encryption AS smtp_encryption_33, u1_.smtp_username AS smtp_username_34, u1_.smtp_password AS smtp_password_35, u1_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_36, u1_.is_default AS is_default_37, u1_.is_active AS is_active_38, u1_.quota_suspended_at AS quota_suspended_at_39, u1_.is_shared_access AS is_shared_access_40, u1_.last_tested_at AS last_tested_at_41, u1_.last_test_status AS last_test_status_42, u1_.last_test_message AS last_test_message_43, u1_.auth_provider AS auth_provider_44, u1_.oauth_access_token AS oauth_access_token_45, u1_.oauth_refresh_token AS oauth_refresh_token_46, u1_.oauth_expires_at AS oauth_expires_at_47, u1_.oauth_account_id AS oauth_account_id_48, u1_.signature_html AS signature_html_49, u1_.signature_enabled AS signature_enabled_50, u1_.inbox_sync_high_watermark AS inbox_sync_high_watermark_51, u1_.inbox_uid_validity AS inbox_uid_validity_52, u1_.created_at AS created_at_53, u1_.updated_at AS updated_at_54, i0_.user_id AS user_id_55, i0_.mailbox_id AS mailbox_id_56, i0_.tenant_id AS tenant_id_57, u1_.user_id AS user_id_58, u1_.platform_mailbox_id AS platform_mailbox_id_59, u1_.sync_source_mailbox_id AS sync_source_mailbox_id_60, u1_.tenant_id AS tenant_id_61 FROM inbox_mail i0_ LEFT JOIN user_mailbox u1_ ON i0_.mailbox_id = u1_.id WHERE i0_.user_id = ? AND i0_.received_at > ? AND i0_.seen = 0 AND i0_.mailbox_id = ? AND i0_.tenant_id = ? ORDER BY i0_.received_at DESC LIMIT 100 Parameters: [`9 "2026-09-01 20:44:38" 31 3`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.imap_uid AS imap_uid_1, i0_.graph_message_id AS graph_message_id_2, i0_.from_address AS from_address_3, i0_.to_addresses AS to_addresses_4, i0_.cc_addresses AS cc_addresses_5, i0_.reply_to AS reply_to_6, i0_.subject AS subject_7, i0_.body_html AS body_html_8, i0_.body_text AS body_text_9, i0_.preview AS preview_10, i0_.message_id AS message_id_11, i0_.in_reply_to AS in_reply_to_12, i0_.references_json AS references_json_13, i0_.mailed_by AS mailed_by_14, i0_.signed_by AS signed_by_15, i0_.security AS security_16, i0_.seen AS seen_17, i0_.has_server_attachments AS has_server_attachments_18, i0_.received_at AS received_at_19, i0_.synced_at AS synced_at_20, u1_.id AS id_21, u1_.access_permission AS access_permission_22, u1_.label AS label_23, u1_.email AS email_24, u1_.incoming_protocol AS incoming_protocol_25, u1_.incoming_host AS incoming_host_26, u1_.incoming_port AS incoming_port_27, u1_.incoming_encryption AS incoming_encryption_28, u1_.incoming_username AS incoming_username_29, u1_.incoming_password AS incoming_password_30, u1_.smtp_host AS smtp_host_31, u1_.smtp_port AS smtp_port_32, u1_.smtp_encryption AS smtp_encryption_33, u1_.smtp_username AS smtp_username_34, u1_.smtp_password AS smtp_password_35, u1_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_36, u1_.is_default AS is_default_37, u1_.is_active AS is_active_38, u1_.quota_suspended_at AS quota_suspended_at_39, u1_.is_shared_access AS is_shared_access_40, u1_.last_tested_at AS last_tested_at_41, u1_.last_test_status AS last_test_status_42, u1_.last_test_message AS last_test_message_43, u1_.auth_provider AS auth_provider_44, u1_.oauth_access_token AS oauth_access_token_45, u1_.oauth_refresh_token AS oauth_refresh_token_46, u1_.oauth_expires_at AS oauth_expires_at_47, u1_.oauth_account_id AS oauth_account_id_48, u1_.signature_html AS signature_html_49, u1_.signature_enabled AS signature_enabled_50, u1_.inbox_sync_high_watermark AS inbox_sync_high_watermark_51, u1_.inbox_uid_validity AS inbox_uid_validity_52, u1_.created_at AS created_at_53, u1_.updated_at AS updated_at_54, i0_.user_id AS user_id_55, i0_.mailbox_id AS mailbox_id_56, i0_.tenant_id AS tenant_id_57, u1_.user_id AS user_id_58, u1_.platform_mailbox_id AS platform_mailbox_id_59, u1_.sync_source_mailbox_id AS sync_source_mailbox_id_60, u1_.tenant_id AS tenant_id_61 FROM inbox_mail i0_ LEFT JOIN user_mailbox u1_ ON i0_.mailbox_id = u1_.id WHERE i0_.user_id = ? AND i0_.received_at > ? AND i0_.seen = 0 AND i0_.mailbox_id = ? AND i0_.tenant_id = ? ORDER BY i0_.received_at DESC LIMIT 100 SELECT i0_.id AS id_0, i0_.imap_uid AS imap_uid_1, i0_.graph_message_id AS graph_message_id_2, i0_.from_address AS from_address_3, i0_.to_addresses AS to_addresses_4, i0_.cc_addresses AS cc_addresses_5, i0_.reply_to AS reply_to_6, i0_.subject AS subject_7, i0_.body_html AS body_html_8, i0_.body_text AS body_text_9, i0_.preview AS preview_10, i0_.message_id AS message_id_11, i0_.in_reply_to AS in_reply_to_12, i0_.references_json AS references_json_13, i0_.mailed_by AS mailed_by_14, i0_.signed_by AS signed_by_15, i0_.security AS security_16, i0_.seen AS seen_17, i0_.has_server_attachments AS has_server_attachments_18, i0_.received_at AS received_at_19, i0_.synced_at AS synced_at_20, u1_.id AS id_21, u1_.access_permission AS access_permission_22, u1_.label AS label_23, u1_.email AS email_24, u1_.incoming_protocol AS incoming_protocol_25, u1_.incoming_host AS incoming_host_26, u1_.incoming_port AS incoming_port_27, u1_.incoming_encryption AS incoming_encryption_28, u1_.incoming_username AS incoming_username_29, u1_.incoming_password AS incoming_password_30, u1_.smtp_host AS smtp_host_31, u1_.smtp_port AS smtp_port_32, u1_.smtp_encryption AS smtp_encryption_33, u1_.smtp_username AS smtp_username_34, u1_.smtp_password AS smtp_password_35, u1_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_36, u1_.is_default AS is_default_37, u1_.is_active AS is_active_38, u1_.quota_suspended_at AS quota_suspended_at_39, u1_.is_shared_access AS is_shared_access_40, u1_.last_tested_at AS last_tested_at_41, u1_.last_test_status AS last_test_status_42, u1_.last_test_message AS last_test_message_43, u1_.auth_provider AS auth_provider_44, u1_.oauth_access_token AS oauth_access_token_45, u1_.oauth_refresh_token AS oauth_refresh_token_46, u1_.oauth_expires_at AS oauth_expires_at_47, u1_.oauth_account_id AS oauth_account_id_48, u1_.signature_html AS signature_html_49, u1_.signature_enabled AS signature_enabled_50, u1_.inbox_sync_high_watermark AS inbox_sync_high_watermark_51, u1_.inbox_uid_validity AS inbox_uid_validity_52, u1_.created_at AS created_at_53, u1_.updated_at AS updated_at_54, i0_.user_id AS user_id_55, i0_.mailbox_id AS mailbox_id_56, i0_.tenant_id AS tenant_id_57, u1_.user_id AS user_id_58, u1_.platform_mailbox_id AS platform_mailbox_id_59, u1_.sync_source_mailbox_id AS sync_source_mailbox_id_60, u1_.tenant_id AS tenant_id_61 FROM inbox_mail i0_ LEFT JOIN user_mailbox u1_ ON i0_.mailbox_id = u1_.id WHERE i0_.user_id = 9 AND i0_.received_at > '2026-09-01 20:44:38' AND i0_.seen = 0 AND i0_.mailbox_id = 31 AND i0_.tenant_id = 3 ORDER BY i0_.received_at DESC LIMIT 100;
9	0.03 ms	SELECT t0.id AS id_1, t0.access_permission AS access_permission_2, t0.label AS label_3, t0.email AS email_4, t0.incoming_protocol AS incoming_protocol_5, t0.incoming_host AS incoming_host_6, t0.incoming_port AS incoming_port_7, t0.incoming_encryption AS incoming_encryption_8, t0.incoming_username AS incoming_username_9, t0.incoming_password AS incoming_password_10, t0.smtp_host AS smtp_host_11, t0.smtp_port AS smtp_port_12, t0.smtp_encryption AS smtp_encryption_13, t0.smtp_username AS smtp_username_14, t0.smtp_password AS smtp_password_15, t0.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_16, t0.is_default AS is_default_17, t0.is_active AS is_active_18, t0.quota_suspended_at AS quota_suspended_at_19, t0.is_shared_access AS is_shared_access_20, t0.last_tested_at AS last_tested_at_21, t0.last_test_status AS last_test_status_22, t0.last_test_message AS last_test_message_23, t0.auth_provider AS auth_provider_24, t0.oauth_access_token AS oauth_access_token_25, t0.oauth_refresh_token AS oauth_refresh_token_26, t0.oauth_expires_at AS oauth_expires_at_27, t0.oauth_account_id AS oauth_account_id_28, t0.signature_html AS signature_html_29, t0.signature_enabled AS signature_enabled_30, t0.inbox_sync_high_watermark AS inbox_sync_high_watermark_31, t0.inbox_uid_validity AS inbox_uid_validity_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.user_id AS user_id_35, t0.platform_mailbox_id AS platform_mailbox_id_36, t0.sync_source_mailbox_id AS sync_source_mailbox_id_37, t0.tenant_id AS tenant_id_38 FROM user_mailbox t0 WHERE t0.id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.access_permission AS access_permission_2, t0.label AS label_3, t0.email AS email_4, t0.incoming_protocol AS incoming_protocol_5, t0.incoming_host AS incoming_host_6, t0.incoming_port AS incoming_port_7, t0.incoming_encryption AS incoming_encryption_8, t0.incoming_username AS incoming_username_9, t0.incoming_password AS incoming_password_10, t0.smtp_host AS smtp_host_11, t0.smtp_port AS smtp_port_12, t0.smtp_encryption AS smtp_encryption_13, t0.smtp_username AS smtp_username_14, t0.smtp_password AS smtp_password_15, t0.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_16, t0.is_default AS is_default_17, t0.is_active AS is_active_18, t0.quota_suspended_at AS quota_suspended_at_19, t0.is_shared_access AS is_shared_access_20, t0.last_tested_at AS last_tested_at_21, t0.last_test_status AS last_test_status_22, t0.last_test_message AS last_test_message_23, t0.auth_provider AS auth_provider_24, t0.oauth_access_token AS oauth_access_token_25, t0.oauth_refresh_token AS oauth_refresh_token_26, t0.oauth_expires_at AS oauth_expires_at_27, t0.oauth_account_id AS oauth_account_id_28, t0.signature_html AS signature_html_29, t0.signature_enabled AS signature_enabled_30, t0.inbox_sync_high_watermark AS inbox_sync_high_watermark_31, t0.inbox_uid_validity AS inbox_uid_validity_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.user_id AS user_id_35, t0.platform_mailbox_id AS platform_mailbox_id_36, t0.sync_source_mailbox_id AS sync_source_mailbox_id_37, t0.tenant_id AS tenant_id_38 FROM user_mailbox t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.access_permission AS access_permission_2, t0.label AS label_3, t0.email AS email_4, t0.incoming_protocol AS incoming_protocol_5, t0.incoming_host AS incoming_host_6, t0.incoming_port AS incoming_port_7, t0.incoming_encryption AS incoming_encryption_8, t0.incoming_username AS incoming_username_9, t0.incoming_password AS incoming_password_10, t0.smtp_host AS smtp_host_11, t0.smtp_port AS smtp_port_12, t0.smtp_encryption AS smtp_encryption_13, t0.smtp_username AS smtp_username_14, t0.smtp_password AS smtp_password_15, t0.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_16, t0.is_default AS is_default_17, t0.is_active AS is_active_18, t0.quota_suspended_at AS quota_suspended_at_19, t0.is_shared_access AS is_shared_access_20, t0.last_tested_at AS last_tested_at_21, t0.last_test_status AS last_test_status_22, t0.last_test_message AS last_test_message_23, t0.auth_provider AS auth_provider_24, t0.oauth_access_token AS oauth_access_token_25, t0.oauth_refresh_token AS oauth_refresh_token_26, t0.oauth_expires_at AS oauth_expires_at_27, t0.oauth_account_id AS oauth_account_id_28, t0.signature_html AS signature_html_29, t0.signature_enabled AS signature_enabled_30, t0.inbox_sync_high_watermark AS inbox_sync_high_watermark_31, t0.inbox_uid_validity AS inbox_uid_validity_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.user_id AS user_id_35, t0.platform_mailbox_id AS platform_mailbox_id_36, t0.sync_source_mailbox_id AS sync_source_mailbox_id_37, t0.tenant_id AS tenant_id_38 FROM user_mailbox t0 WHERE t0.id = 12;
10	0.82 ms	SELECT i0_.id AS id_0, i0_.imap_uid AS imap_uid_1, i0_.graph_message_id AS graph_message_id_2, i0_.from_address AS from_address_3, i0_.to_addresses AS to_addresses_4, i0_.cc_addresses AS cc_addresses_5, i0_.reply_to AS reply_to_6, i0_.subject AS subject_7, i0_.body_html AS body_html_8, i0_.body_text AS body_text_9, i0_.preview AS preview_10, i0_.message_id AS message_id_11, i0_.in_reply_to AS in_reply_to_12, i0_.references_json AS references_json_13, i0_.mailed_by AS mailed_by_14, i0_.signed_by AS signed_by_15, i0_.security AS security_16, i0_.seen AS seen_17, i0_.has_server_attachments AS has_server_attachments_18, i0_.received_at AS received_at_19, i0_.synced_at AS synced_at_20, u1_.id AS id_21, u1_.access_permission AS access_permission_22, u1_.label AS label_23, u1_.email AS email_24, u1_.incoming_protocol AS incoming_protocol_25, u1_.incoming_host AS incoming_host_26, u1_.incoming_port AS incoming_port_27, u1_.incoming_encryption AS incoming_encryption_28, u1_.incoming_username AS incoming_username_29, u1_.incoming_password AS incoming_password_30, u1_.smtp_host AS smtp_host_31, u1_.smtp_port AS smtp_port_32, u1_.smtp_encryption AS smtp_encryption_33, u1_.smtp_username AS smtp_username_34, u1_.smtp_password AS smtp_password_35, u1_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_36, u1_.is_default AS is_default_37, u1_.is_active AS is_active_38, u1_.quota_suspended_at AS quota_suspended_at_39, u1_.is_shared_access AS is_shared_access_40, u1_.last_tested_at AS last_tested_at_41, u1_.last_test_status AS last_test_status_42, u1_.last_test_message AS last_test_message_43, u1_.auth_provider AS auth_provider_44, u1_.oauth_access_token AS oauth_access_token_45, u1_.oauth_refresh_token AS oauth_refresh_token_46, u1_.oauth_expires_at AS oauth_expires_at_47, u1_.oauth_account_id AS oauth_account_id_48, u1_.signature_html AS signature_html_49, u1_.signature_enabled AS signature_enabled_50, u1_.inbox_sync_high_watermark AS inbox_sync_high_watermark_51, u1_.inbox_uid_validity AS inbox_uid_validity_52, u1_.created_at AS created_at_53, u1_.updated_at AS updated_at_54, i0_.user_id AS user_id_55, i0_.mailbox_id AS mailbox_id_56, i0_.tenant_id AS tenant_id_57, u1_.user_id AS user_id_58, u1_.platform_mailbox_id AS platform_mailbox_id_59, u1_.sync_source_mailbox_id AS sync_source_mailbox_id_60, u1_.tenant_id AS tenant_id_61 FROM inbox_mail i0_ LEFT JOIN user_mailbox u1_ ON i0_.mailbox_id = u1_.id LEFT JOIN inbox_mail_user_read i2_ ON (i2_.inbox_mail_id = i0_.id AND i2_.user_id = ?) WHERE i0_.user_id = ? AND i0_.received_at > ? AND i2_.id IS NULL AND i0_.mailbox_id = ? AND i0_.tenant_id = ? ORDER BY i0_.received_at DESC LIMIT 100 Parameters: [`9 6 "2026-09-01 20:44:38" 12 3`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.imap_uid AS imap_uid_1, i0_.graph_message_id AS graph_message_id_2, i0_.from_address AS from_address_3, i0_.to_addresses AS to_addresses_4, i0_.cc_addresses AS cc_addresses_5, i0_.reply_to AS reply_to_6, i0_.subject AS subject_7, i0_.body_html AS body_html_8, i0_.body_text AS body_text_9, i0_.preview AS preview_10, i0_.message_id AS message_id_11, i0_.in_reply_to AS in_reply_to_12, i0_.references_json AS references_json_13, i0_.mailed_by AS mailed_by_14, i0_.signed_by AS signed_by_15, i0_.security AS security_16, i0_.seen AS seen_17, i0_.has_server_attachments AS has_server_attachments_18, i0_.received_at AS received_at_19, i0_.synced_at AS synced_at_20, u1_.id AS id_21, u1_.access_permission AS access_permission_22, u1_.label AS label_23, u1_.email AS email_24, u1_.incoming_protocol AS incoming_protocol_25, u1_.incoming_host AS incoming_host_26, u1_.incoming_port AS incoming_port_27, u1_.incoming_encryption AS incoming_encryption_28, u1_.incoming_username AS incoming_username_29, u1_.incoming_password AS incoming_password_30, u1_.smtp_host AS smtp_host_31, u1_.smtp_port AS smtp_port_32, u1_.smtp_encryption AS smtp_encryption_33, u1_.smtp_username AS smtp_username_34, u1_.smtp_password AS smtp_password_35, u1_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_36, u1_.is_default AS is_default_37, u1_.is_active AS is_active_38, u1_.quota_suspended_at AS quota_suspended_at_39, u1_.is_shared_access AS is_shared_access_40, u1_.last_tested_at AS last_tested_at_41, u1_.last_test_status AS last_test_status_42, u1_.last_test_message AS last_test_message_43, u1_.auth_provider AS auth_provider_44, u1_.oauth_access_token AS oauth_access_token_45, u1_.oauth_refresh_token AS oauth_refresh_token_46, u1_.oauth_expires_at AS oauth_expires_at_47, u1_.oauth_account_id AS oauth_account_id_48, u1_.signature_html AS signature_html_49, u1_.signature_enabled AS signature_enabled_50, u1_.inbox_sync_high_watermark AS inbox_sync_high_watermark_51, u1_.inbox_uid_validity AS inbox_uid_validity_52, u1_.created_at AS created_at_53, u1_.updated_at AS updated_at_54, i0_.user_id AS user_id_55, i0_.mailbox_id AS mailbox_id_56, i0_.tenant_id AS tenant_id_57, u1_.user_id AS user_id_58, u1_.platform_mailbox_id AS platform_mailbox_id_59, u1_.sync_source_mailbox_id AS sync_source_mailbox_id_60, u1_.tenant_id AS tenant_id_61 FROM inbox_mail i0_ LEFT JOIN user_mailbox u1_ ON i0_.mailbox_id = u1_.id LEFT JOIN inbox_mail_user_read i2_ ON ( i2_.inbox_mail_id = i0_.id AND i2_.user_id = ? ) WHERE i0_.user_id = ? AND i0_.received_at > ? AND i2_.id IS NULL AND i0_.mailbox_id = ? AND i0_.tenant_id = ? ORDER BY i0_.received_at DESC LIMIT 100 SELECT i0_.id AS id_0, i0_.imap_uid AS imap_uid_1, i0_.graph_message_id AS graph_message_id_2, i0_.from_address AS from_address_3, i0_.to_addresses AS to_addresses_4, i0_.cc_addresses AS cc_addresses_5, i0_.reply_to AS reply_to_6, i0_.subject AS subject_7, i0_.body_html AS body_html_8, i0_.body_text AS body_text_9, i0_.preview AS preview_10, i0_.message_id AS message_id_11, i0_.in_reply_to AS in_reply_to_12, i0_.references_json AS references_json_13, i0_.mailed_by AS mailed_by_14, i0_.signed_by AS signed_by_15, i0_.security AS security_16, i0_.seen AS seen_17, i0_.has_server_attachments AS has_server_attachments_18, i0_.received_at AS received_at_19, i0_.synced_at AS synced_at_20, u1_.id AS id_21, u1_.access_permission AS access_permission_22, u1_.label AS label_23, u1_.email AS email_24, u1_.incoming_protocol AS incoming_protocol_25, u1_.incoming_host AS incoming_host_26, u1_.incoming_port AS incoming_port_27, u1_.incoming_encryption AS incoming_encryption_28, u1_.incoming_username AS incoming_username_29, u1_.incoming_password AS incoming_password_30, u1_.smtp_host AS smtp_host_31, u1_.smtp_port AS smtp_port_32, u1_.smtp_encryption AS smtp_encryption_33, u1_.smtp_username AS smtp_username_34, u1_.smtp_password AS smtp_password_35, u1_.use_same_credentials_for_smtp AS use_same_credentials_for_smtp_36, u1_.is_default AS is_default_37, u1_.is_active AS is_active_38, u1_.quota_suspended_at AS quota_suspended_at_39, u1_.is_shared_access AS is_shared_access_40, u1_.last_tested_at AS last_tested_at_41, u1_.last_test_status AS last_test_status_42, u1_.last_test_message AS last_test_message_43, u1_.auth_provider AS auth_provider_44, u1_.oauth_access_token AS oauth_access_token_45, u1_.oauth_refresh_token AS oauth_refresh_token_46, u1_.oauth_expires_at AS oauth_expires_at_47, u1_.oauth_account_id AS oauth_account_id_48, u1_.signature_html AS signature_html_49, u1_.signature_enabled AS signature_enabled_50, u1_.inbox_sync_high_watermark AS inbox_sync_high_watermark_51, u1_.inbox_uid_validity AS inbox_uid_validity_52, u1_.created_at AS created_at_53, u1_.updated_at AS updated_at_54, i0_.user_id AS user_id_55, i0_.mailbox_id AS mailbox_id_56, i0_.tenant_id AS tenant_id_57, u1_.user_id AS user_id_58, u1_.platform_mailbox_id AS platform_mailbox_id_59, u1_.sync_source_mailbox_id AS sync_source_mailbox_id_60, u1_.tenant_id AS tenant_id_61 FROM inbox_mail i0_ LEFT JOIN user_mailbox u1_ ON i0_.mailbox_id = u1_.id LEFT JOIN inbox_mail_user_read i2_ ON (i2_.inbox_mail_id = i0_.id AND i2_.user_id = 9) WHERE i0_.user_id = 6 AND i0_.received_at > '2026-09-01 20:44:38' AND i2_.id IS NULL AND i0_.mailbox_id = 12 AND i0_.tenant_id = 3 ORDER BY i0_.received_at DESC LIMIT 100;
11	0.38 ms	SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.due_date AS due_date_5, t0_.start_date AS start_date_6, t0_.status AS status_7, t0_.position AS position_8, t0_.progress AS progress_9, p1_.id AS id_10, p1_.title AS title_11, p1_.description AS description_12, p1_.color AS color_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.due_date AS due_date_16, p1_.status AS status_17, t0_.project_id AS project_id_18, t0_.parent_id AS parent_id_19, t0_.tenant_id AS tenant_id_20, p1_.owner_id AS owner_id_21, p1_.parent_id AS parent_id_22, p1_.tenant_id AS tenant_id_23 FROM task t0_ INNER JOIN task_assignee t3_ ON t0_.id = t3_.task_id INNER JOIN `user` u2_ ON u2_.id = t3_.user_id INNER JOIN project p1_ ON t0_.project_id = p1_.id WHERE t0_.tenant_id = ? AND u2_.id = ? AND ((t0_.updated_at IS NOT NULL AND t0_.updated_at > ?) OR (t0_.updated_at IS NULL AND t0_.created_at > ?)) ORDER BY t0_.updated_at DESC, t0_.created_at DESC LIMIT 100 Parameters: [`3 9 "2026-09-01 20:44:38" "2026-09-01 20:44:38"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.due_date AS due_date_5, t0_.start_date AS start_date_6, t0_.status AS status_7, t0_.position AS position_8, t0_.progress AS progress_9, p1_.id AS id_10, p1_.title AS title_11, p1_.description AS description_12, p1_.color AS color_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.due_date AS due_date_16, p1_.status AS status_17, t0_.project_id AS project_id_18, t0_.parent_id AS parent_id_19, t0_.tenant_id AS tenant_id_20, p1_.owner_id AS owner_id_21, p1_.parent_id AS parent_id_22, p1_.tenant_id AS tenant_id_23 FROM task t0_ INNER JOIN task_assignee t3_ ON t0_.id = t3_.task_id INNER JOIN `user` u2_ ON u2_.id = t3_.user_id INNER JOIN project p1_ ON t0_.project_id = p1_.id WHERE t0_.tenant_id = ? AND u2_.id = ? AND ( ( t0_.updated_at IS NOT NULL AND t0_.updated_at > ? ) OR ( t0_.updated_at IS NULL AND t0_.created_at > ? ) ) ORDER BY t0_.updated_at DESC, t0_.created_at DESC LIMIT 100 SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.due_date AS due_date_5, t0_.start_date AS start_date_6, t0_.status AS status_7, t0_.position AS position_8, t0_.progress AS progress_9, p1_.id AS id_10, p1_.title AS title_11, p1_.description AS description_12, p1_.color AS color_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.due_date AS due_date_16, p1_.status AS status_17, t0_.project_id AS project_id_18, t0_.parent_id AS parent_id_19, t0_.tenant_id AS tenant_id_20, p1_.owner_id AS owner_id_21, p1_.parent_id AS parent_id_22, p1_.tenant_id AS tenant_id_23 FROM task t0_ INNER JOIN task_assignee t3_ ON t0_.id = t3_.task_id INNER JOIN `user` u2_ ON u2_.id = t3_.user_id INNER JOIN project p1_ ON t0_.project_id = p1_.id WHERE t0_.tenant_id = 3 AND u2_.id = 9 AND ((t0_.updated_at IS NOT NULL AND t0_.updated_at > '2026-09-01 20:44:38') OR (t0_.updated_at IS NULL AND t0_.created_at > '2026-09-01 20:44:38')) ORDER BY t0_.updated_at DESC, t0_.created_at DESC LIMIT 100;
12	0.19 ms	SELECT t0_.id AS id_0, t0_.invited_email AS invited_email_1, t0_.token AS token_2, t0_.status AS status_3, t0_.created_at AS created_at_4, t0_.accepted_at AS accepted_at_5, t0_.expires_at AS expires_at_6, t1_.id AS id_7, t1_.title AS title_8, t1_.description AS description_9, t1_.created_at AS created_at_10, t1_.updated_at AS updated_at_11, t1_.due_date AS due_date_12, t1_.start_date AS start_date_13, t1_.status AS status_14, t1_.position AS position_15, t1_.progress AS progress_16, p2_.id AS id_17, p2_.title AS title_18, p2_.description AS description_19, p2_.color AS color_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, p2_.due_date AS due_date_23, p2_.status AS status_24, t0_.task_id AS task_id_25, t0_.invited_user_id AS invited_user_id_26, t0_.invited_by_id AS invited_by_id_27, t1_.project_id AS project_id_28, t1_.parent_id AS parent_id_29, t1_.tenant_id AS tenant_id_30, p2_.owner_id AS owner_id_31, p2_.parent_id AS parent_id_32, p2_.tenant_id AS tenant_id_33 FROM task_invitation t0_ INNER JOIN task t1_ ON t0_.task_id = t1_.id INNER JOIN project p2_ ON t1_.project_id = p2_.id WHERE t0_.status = ? AND t0_.created_at > ? AND (t0_.invited_user_id = ? OR t0_.invited_email = ?) AND p2_.tenant_id = ? ORDER BY t0_.created_at DESC LIMIT 100 Parameters: [`"pending" "2026-09-01 20:44:38" 9 "marco.ariano@group.ulixe.com" 3`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.invited_email AS invited_email_1, t0_.token AS token_2, t0_.status AS status_3, t0_.created_at AS created_at_4, t0_.accepted_at AS accepted_at_5, t0_.expires_at AS expires_at_6, t1_.id AS id_7, t1_.title AS title_8, t1_.description AS description_9, t1_.created_at AS created_at_10, t1_.updated_at AS updated_at_11, t1_.due_date AS due_date_12, t1_.start_date AS start_date_13, t1_.status AS status_14, t1_.position AS position_15, t1_.progress AS progress_16, p2_.id AS id_17, p2_.title AS title_18, p2_.description AS description_19, p2_.color AS color_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, p2_.due_date AS due_date_23, p2_.status AS status_24, t0_.task_id AS task_id_25, t0_.invited_user_id AS invited_user_id_26, t0_.invited_by_id AS invited_by_id_27, t1_.project_id AS project_id_28, t1_.parent_id AS parent_id_29, t1_.tenant_id AS tenant_id_30, p2_.owner_id AS owner_id_31, p2_.parent_id AS parent_id_32, p2_.tenant_id AS tenant_id_33 FROM task_invitation t0_ INNER JOIN task t1_ ON t0_.task_id = t1_.id INNER JOIN project p2_ ON t1_.project_id = p2_.id WHERE t0_.status = ? AND t0_.created_at > ? AND ( t0_.invited_user_id = ? OR t0_.invited_email = ? ) AND p2_.tenant_id = ? ORDER BY t0_.created_at DESC LIMIT 100 SELECT t0_.id AS id_0, t0_.invited_email AS invited_email_1, t0_.token AS token_2, t0_.status AS status_3, t0_.created_at AS created_at_4, t0_.accepted_at AS accepted_at_5, t0_.expires_at AS expires_at_6, t1_.id AS id_7, t1_.title AS title_8, t1_.description AS description_9, t1_.created_at AS created_at_10, t1_.updated_at AS updated_at_11, t1_.due_date AS due_date_12, t1_.start_date AS start_date_13, t1_.status AS status_14, t1_.position AS position_15, t1_.progress AS progress_16, p2_.id AS id_17, p2_.title AS title_18, p2_.description AS description_19, p2_.color AS color_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, p2_.due_date AS due_date_23, p2_.status AS status_24, t0_.task_id AS task_id_25, t0_.invited_user_id AS invited_user_id_26, t0_.invited_by_id AS invited_by_id_27, t1_.project_id AS project_id_28, t1_.parent_id AS parent_id_29, t1_.tenant_id AS tenant_id_30, p2_.owner_id AS owner_id_31, p2_.parent_id AS parent_id_32, p2_.tenant_id AS tenant_id_33 FROM task_invitation t0_ INNER JOIN task t1_ ON t0_.task_id = t1_.id INNER JOIN project p2_ ON t1_.project_id = p2_.id WHERE t0_.status = 'pending' AND t0_.created_at > '2026-09-01 20:44:38' AND (t0_.invited_user_id = 9 OR t0_.invited_email = 'marco.ariano@group.ulixe.com') AND p2_.tenant_id = 3 ORDER BY t0_.created_at DESC LIMIT 100;
13	0.19 ms	SELECT t0_.assigned_at AS assigned_at_0, t1_.id AS id_1, t1_.code AS code_2, t1_.subject AS subject_3, t1_.description AS description_4, t1_.status AS status_5, t1_.priority AS priority_6, t1_.issue_type AS issue_type_7, t1_.category AS category_8, t1_.portal_token AS portal_token_9, t1_.source AS source_10, t1_.due_date AS due_date_11, t1_.resolved_at AS resolved_at_12, t1_.closed_at AS closed_at_13, t1_.created_at AS created_at_14, t1_.updated_at AS updated_at_15, t1_.last_customer_seen_at AS last_customer_seen_at_16, t1_.customer_satisfaction AS customer_satisfaction_17, t1_.customer_feedback_comment AS customer_feedback_comment_18, t1_.customer_feedback_at AS customer_feedback_at_19, t1_.customer_close_reason AS customer_close_reason_20, t1_.template_name_snapshot AS template_name_snapshot_21, c2_.id AS id_22, c2_.first_name AS first_name_23, c2_.last_name AS last_name_24, c2_.email AS email_25, c2_.password AS password_26, c2_.phone AS phone_27, c2_.job_title AS job_title_28, c2_.company_name AS company_name_29, c2_.notes AS notes_30, c2_.is_active AS is_active_31, c2_.email_notifications AS email_notifications_32, c2_.created_at AS created_at_33, c2_.updated_at AS updated_at_34, c2_.sip_extension AS sip_extension_35, c2_.voip_enabled AS voip_enabled_36, c2_.sip_secret_encrypted AS sip_secret_encrypted_37, t0_.ticket_id AS ticket_id_38, t0_.user_id AS user_id_39, t1_.requester_id AS requester_id_40, t1_.company_id AS company_id_41, t1_.current_support_level_id AS current_support_level_id_42, t1_.project_id AS project_id_43, t1_.customer_id AS customer_id_44, t1_.supplier_id AS supplier_id_45, t1_.catalog_product_id AS catalog_product_id_46, t1_.widget_site_id AS widget_site_id_47, t1_.updated_by_id AS updated_by_id_48, t1_.updated_by_customer_id AS updated_by_customer_id_49, t1_.updated_by_supplier_id AS updated_by_supplier_id_50, t1_.tenant_id AS tenant_id_51, t1_.source_tenant_id AS source_tenant_id_52, t1_.ticket_template_id AS ticket_template_id_53, c2_.company_id AS company_id_54, c2_.service_company_id AS service_company_id_55, c2_.created_by_id AS created_by_id_56, c2_.tenant_id AS tenant_id_57 FROM ticket_assignee t0_ INNER JOIN ticket t1_ ON t0_.ticket_id = t1_.id LEFT JOIN customer c2_ ON t1_.customer_id = c2_.id WHERE t0_.user_id = ? AND t0_.assigned_at >= ? ORDER BY t0_.assigned_at DESC LIMIT 100 Parameters: [`9 "2026-09-01 20:44:38"`] View formatted query View runnable query Explain query SELECT t0_.assigned_at AS assigned_at_0, t1_.id AS id_1, t1_.code AS code_2, t1_.subject AS subject_3, t1_.description AS description_4, t1_.status AS status_5, t1_.priority AS priority_6, t1_.issue_type AS issue_type_7, t1_.category AS category_8, t1_.portal_token AS portal_token_9, t1_.source AS source_10, t1_.due_date AS due_date_11, t1_.resolved_at AS resolved_at_12, t1_.closed_at AS closed_at_13, t1_.created_at AS created_at_14, t1_.updated_at AS updated_at_15, t1_.last_customer_seen_at AS last_customer_seen_at_16, t1_.customer_satisfaction AS customer_satisfaction_17, t1_.customer_feedback_comment AS customer_feedback_comment_18, t1_.customer_feedback_at AS customer_feedback_at_19, t1_.customer_close_reason AS customer_close_reason_20, t1_.template_name_snapshot AS template_name_snapshot_21, c2_.id AS id_22, c2_.first_name AS first_name_23, c2_.last_name AS last_name_24, c2_.email AS email_25, c2_.password AS password_26, c2_.phone AS phone_27, c2_.job_title AS job_title_28, c2_.company_name AS company_name_29, c2_.notes AS notes_30, c2_.is_active AS is_active_31, c2_.email_notifications AS email_notifications_32, c2_.created_at AS created_at_33, c2_.updated_at AS updated_at_34, c2_.sip_extension AS sip_extension_35, c2_.voip_enabled AS voip_enabled_36, c2_.sip_secret_encrypted AS sip_secret_encrypted_37, t0_.ticket_id AS ticket_id_38, t0_.user_id AS user_id_39, t1_.requester_id AS requester_id_40, t1_.company_id AS company_id_41, t1_.current_support_level_id AS current_support_level_id_42, t1_.project_id AS project_id_43, t1_.customer_id AS customer_id_44, t1_.supplier_id AS supplier_id_45, t1_.catalog_product_id AS catalog_product_id_46, t1_.widget_site_id AS widget_site_id_47, t1_.updated_by_id AS updated_by_id_48, t1_.updated_by_customer_id AS updated_by_customer_id_49, t1_.updated_by_supplier_id AS updated_by_supplier_id_50, t1_.tenant_id AS tenant_id_51, t1_.source_tenant_id AS source_tenant_id_52, t1_.ticket_template_id AS ticket_template_id_53, c2_.company_id AS company_id_54, c2_.service_company_id AS service_company_id_55, c2_.created_by_id AS created_by_id_56, c2_.tenant_id AS tenant_id_57 FROM ticket_assignee t0_ INNER JOIN ticket t1_ ON t0_.ticket_id = t1_.id LEFT JOIN customer c2_ ON t1_.customer_id = c2_.id WHERE t0_.user_id = ? AND t0_.assigned_at >= ? ORDER BY t0_.assigned_at DESC LIMIT 100 SELECT t0_.assigned_at AS assigned_at_0, t1_.id AS id_1, t1_.code AS code_2, t1_.subject AS subject_3, t1_.description AS description_4, t1_.status AS status_5, t1_.priority AS priority_6, t1_.issue_type AS issue_type_7, t1_.category AS category_8, t1_.portal_token AS portal_token_9, t1_.source AS source_10, t1_.due_date AS due_date_11, t1_.resolved_at AS resolved_at_12, t1_.closed_at AS closed_at_13, t1_.created_at AS created_at_14, t1_.updated_at AS updated_at_15, t1_.last_customer_seen_at AS last_customer_seen_at_16, t1_.customer_satisfaction AS customer_satisfaction_17, t1_.customer_feedback_comment AS customer_feedback_comment_18, t1_.customer_feedback_at AS customer_feedback_at_19, t1_.customer_close_reason AS customer_close_reason_20, t1_.template_name_snapshot AS template_name_snapshot_21, c2_.id AS id_22, c2_.first_name AS first_name_23, c2_.last_name AS last_name_24, c2_.email AS email_25, c2_.password AS password_26, c2_.phone AS phone_27, c2_.job_title AS job_title_28, c2_.company_name AS company_name_29, c2_.notes AS notes_30, c2_.is_active AS is_active_31, c2_.email_notifications AS email_notifications_32, c2_.created_at AS created_at_33, c2_.updated_at AS updated_at_34, c2_.sip_extension AS sip_extension_35, c2_.voip_enabled AS voip_enabled_36, c2_.sip_secret_encrypted AS sip_secret_encrypted_37, t0_.ticket_id AS ticket_id_38, t0_.user_id AS user_id_39, t1_.requester_id AS requester_id_40, t1_.company_id AS company_id_41, t1_.current_support_level_id AS current_support_level_id_42, t1_.project_id AS project_id_43, t1_.customer_id AS customer_id_44, t1_.supplier_id AS supplier_id_45, t1_.catalog_product_id AS catalog_product_id_46, t1_.widget_site_id AS widget_site_id_47, t1_.updated_by_id AS updated_by_id_48, t1_.updated_by_customer_id AS updated_by_customer_id_49, t1_.updated_by_supplier_id AS updated_by_supplier_id_50, t1_.tenant_id AS tenant_id_51, t1_.source_tenant_id AS source_tenant_id_52, t1_.ticket_template_id AS ticket_template_id_53, c2_.company_id AS company_id_54, c2_.service_company_id AS service_company_id_55, c2_.created_by_id AS created_by_id_56, c2_.tenant_id AS tenant_id_57 FROM ticket_assignee t0_ INNER JOIN ticket t1_ ON t0_.ticket_id = t1_.id LEFT JOIN customer c2_ ON t1_.customer_id = c2_.id WHERE t0_.user_id = 9 AND t0_.assigned_at >= '2026-09-01 20:44:38' ORDER BY t0_.assigned_at DESC LIMIT 100;
14	0.54 ms	SELECT DISTINCT t0_.id AS id_0, t0_.code AS code_1, t0_.subject AS subject_2, t0_.description AS description_3, t0_.status AS status_4, t0_.priority AS priority_5, t0_.issue_type AS issue_type_6, t0_.category AS category_7, t0_.portal_token AS portal_token_8, t0_.source AS source_9, t0_.due_date AS due_date_10, t0_.resolved_at AS resolved_at_11, t0_.closed_at AS closed_at_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.last_customer_seen_at AS last_customer_seen_at_15, t0_.customer_satisfaction AS customer_satisfaction_16, t0_.customer_feedback_comment AS customer_feedback_comment_17, t0_.customer_feedback_at AS customer_feedback_at_18, t0_.customer_close_reason AS customer_close_reason_19, t0_.template_name_snapshot AS template_name_snapshot_20, c1_.id AS id_21, c1_.first_name AS first_name_22, c1_.last_name AS last_name_23, c1_.email AS email_24, c1_.password AS password_25, c1_.phone AS phone_26, c1_.job_title AS job_title_27, c1_.company_name AS company_name_28, c1_.notes AS notes_29, c1_.is_active AS is_active_30, c1_.email_notifications AS email_notifications_31, c1_.created_at AS created_at_32, c1_.updated_at AS updated_at_33, c1_.sip_extension AS sip_extension_34, c1_.voip_enabled AS voip_enabled_35, c1_.sip_secret_encrypted AS sip_secret_encrypted_36, t0_.requester_id AS requester_id_37, t0_.company_id AS company_id_38, t0_.current_support_level_id AS current_support_level_id_39, t0_.project_id AS project_id_40, t0_.customer_id AS customer_id_41, t0_.supplier_id AS supplier_id_42, t0_.catalog_product_id AS catalog_product_id_43, t0_.widget_site_id AS widget_site_id_44, t0_.updated_by_id AS updated_by_id_45, t0_.updated_by_customer_id AS updated_by_customer_id_46, t0_.updated_by_supplier_id AS updated_by_supplier_id_47, t0_.tenant_id AS tenant_id_48, t0_.source_tenant_id AS source_tenant_id_49, t0_.ticket_template_id AS ticket_template_id_50, c1_.company_id AS company_id_51, c1_.service_company_id AS service_company_id_52, c1_.created_by_id AS created_by_id_53, c1_.tenant_id AS tenant_id_54 FROM ticket t0_ LEFT JOIN ticket_assignee t2_ ON t0_.id = t2_.ticket_id LEFT JOIN ticket_user_read t3_ ON (t3_.ticket_id = t0_.id AND t3_.user_id = ?) LEFT JOIN customer c1_ ON t0_.customer_id = c1_.id WHERE t0_.updated_at IS NOT NULL AND t0_.updated_at >= ? AND t0_.updated_at > t0_.created_at AND ((t2_.user_id = ? OR t0_.requester_id = ?)) AND ((t3_.id IS NULL OR t3_.last_read_at < t0_.updated_at)) AND t0_.tenant_id = ? ORDER BY t0_.updated_at DESC LIMIT 100 Parameters: [`9 "2026-09-01 20:44:38" 9 9 3`] View formatted query View runnable query Explain query SELECT DISTINCT t0_.id AS id_0, t0_.code AS code_1, t0_.subject AS subject_2, t0_.description AS description_3, t0_.status AS status_4, t0_.priority AS priority_5, t0_.issue_type AS issue_type_6, t0_.category AS category_7, t0_.portal_token AS portal_token_8, t0_.source AS source_9, t0_.due_date AS due_date_10, t0_.resolved_at AS resolved_at_11, t0_.closed_at AS closed_at_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.last_customer_seen_at AS last_customer_seen_at_15, t0_.customer_satisfaction AS customer_satisfaction_16, t0_.customer_feedback_comment AS customer_feedback_comment_17, t0_.customer_feedback_at AS customer_feedback_at_18, t0_.customer_close_reason AS customer_close_reason_19, t0_.template_name_snapshot AS template_name_snapshot_20, c1_.id AS id_21, c1_.first_name AS first_name_22, c1_.last_name AS last_name_23, c1_.email AS email_24, c1_.password AS password_25, c1_.phone AS phone_26, c1_.job_title AS job_title_27, c1_.company_name AS company_name_28, c1_.notes AS notes_29, c1_.is_active AS is_active_30, c1_.email_notifications AS email_notifications_31, c1_.created_at AS created_at_32, c1_.updated_at AS updated_at_33, c1_.sip_extension AS sip_extension_34, c1_.voip_enabled AS voip_enabled_35, c1_.sip_secret_encrypted AS sip_secret_encrypted_36, t0_.requester_id AS requester_id_37, t0_.company_id AS company_id_38, t0_.current_support_level_id AS current_support_level_id_39, t0_.project_id AS project_id_40, t0_.customer_id AS customer_id_41, t0_.supplier_id AS supplier_id_42, t0_.catalog_product_id AS catalog_product_id_43, t0_.widget_site_id AS widget_site_id_44, t0_.updated_by_id AS updated_by_id_45, t0_.updated_by_customer_id AS updated_by_customer_id_46, t0_.updated_by_supplier_id AS updated_by_supplier_id_47, t0_.tenant_id AS tenant_id_48, t0_.source_tenant_id AS source_tenant_id_49, t0_.ticket_template_id AS ticket_template_id_50, c1_.company_id AS company_id_51, c1_.service_company_id AS service_company_id_52, c1_.created_by_id AS created_by_id_53, c1_.tenant_id AS tenant_id_54 FROM ticket t0_ LEFT JOIN ticket_assignee t2_ ON t0_.id = t2_.ticket_id LEFT JOIN ticket_user_read t3_ ON ( t3_.ticket_id = t0_.id AND t3_.user_id = ? ) LEFT JOIN customer c1_ ON t0_.customer_id = c1_.id WHERE t0_.updated_at IS NOT NULL AND t0_.updated_at >= ? AND t0_.updated_at > t0_.created_at AND ( ( t2_.user_id = ? OR t0_.requester_id = ? ) ) AND ( ( t3_.id IS NULL OR t3_.last_read_at < t0_.updated_at ) ) AND t0_.tenant_id = ? ORDER BY t0_.updated_at DESC LIMIT 100 SELECT DISTINCT t0_.id AS id_0, t0_.code AS code_1, t0_.subject AS subject_2, t0_.description AS description_3, t0_.status AS status_4, t0_.priority AS priority_5, t0_.issue_type AS issue_type_6, t0_.category AS category_7, t0_.portal_token AS portal_token_8, t0_.source AS source_9, t0_.due_date AS due_date_10, t0_.resolved_at AS resolved_at_11, t0_.closed_at AS closed_at_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.last_customer_seen_at AS last_customer_seen_at_15, t0_.customer_satisfaction AS customer_satisfaction_16, t0_.customer_feedback_comment AS customer_feedback_comment_17, t0_.customer_feedback_at AS customer_feedback_at_18, t0_.customer_close_reason AS customer_close_reason_19, t0_.template_name_snapshot AS template_name_snapshot_20, c1_.id AS id_21, c1_.first_name AS first_name_22, c1_.last_name AS last_name_23, c1_.email AS email_24, c1_.password AS password_25, c1_.phone AS phone_26, c1_.job_title AS job_title_27, c1_.company_name AS company_name_28, c1_.notes AS notes_29, c1_.is_active AS is_active_30, c1_.email_notifications AS email_notifications_31, c1_.created_at AS created_at_32, c1_.updated_at AS updated_at_33, c1_.sip_extension AS sip_extension_34, c1_.voip_enabled AS voip_enabled_35, c1_.sip_secret_encrypted AS sip_secret_encrypted_36, t0_.requester_id AS requester_id_37, t0_.company_id AS company_id_38, t0_.current_support_level_id AS current_support_level_id_39, t0_.project_id AS project_id_40, t0_.customer_id AS customer_id_41, t0_.supplier_id AS supplier_id_42, t0_.catalog_product_id AS catalog_product_id_43, t0_.widget_site_id AS widget_site_id_44, t0_.updated_by_id AS updated_by_id_45, t0_.updated_by_customer_id AS updated_by_customer_id_46, t0_.updated_by_supplier_id AS updated_by_supplier_id_47, t0_.tenant_id AS tenant_id_48, t0_.source_tenant_id AS source_tenant_id_49, t0_.ticket_template_id AS ticket_template_id_50, c1_.company_id AS company_id_51, c1_.service_company_id AS service_company_id_52, c1_.created_by_id AS created_by_id_53, c1_.tenant_id AS tenant_id_54 FROM ticket t0_ LEFT JOIN ticket_assignee t2_ ON t0_.id = t2_.ticket_id LEFT JOIN ticket_user_read t3_ ON (t3_.ticket_id = t0_.id AND t3_.user_id = 9) LEFT JOIN customer c1_ ON t0_.customer_id = c1_.id WHERE t0_.updated_at IS NOT NULL AND t0_.updated_at >= '2026-09-01 20:44:38' AND t0_.updated_at > t0_.created_at AND ((t2_.user_id = 9 OR t0_.requester_id = 9)) AND ((t3_.id IS NULL OR t3_.last_read_at < t0_.updated_at)) AND t0_.tenant_id = 3 ORDER BY t0_.updated_at DESC LIMIT 100;
15	0.04 ms	SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC Parameters: [`84`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = 84 ORDER BY t0.created_at ASC;
16	0.02 ms	SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC Parameters: [`139`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = 139 ORDER BY t0.created_at ASC;
17	0.01 ms	SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC Parameters: [`123`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = 123 ORDER BY t0.created_at ASC;
18	0.09 ms	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 = ? Parameters: [`16`] View formatted query View runnable query Explain query 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 = 16;
19	0.01 ms	SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC Parameters: [`108`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.is_internal AS is_internal_4, t0.visible_to_supplier AS visible_to_supplier_5, t0.created_at AS created_at_6, t0.ticket_id AS ticket_id_7, t0.author_id AS author_id_8, t0.author_customer_id AS author_customer_id_9, t0.author_supplier_id AS author_supplier_id_10 FROM ticket_comment t0 WHERE t0.ticket_id = 108 ORDER BY t0.created_at ASC;
20	0.23 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.location AS location_3, c0_.ics_uid AS ics_uid_4, c0_.starts_at AS starts_at_5, c0_.ends_at AS ends_at_6, c0_.all_day AS all_day_7, c0_.color AS color_8, c0_.alarm_minutes_before AS alarm_minutes_before_9, c0_.alarm_sent_at AS alarm_sent_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.user_id AS user_id_13 FROM calendar_event c0_ WHERE (c0_.user_id = ? OR EXISTS (SELECT 1 FROM calendar_event_share c1_ WHERE c1_.calendar_event_id = c0_.id AND c1_.user_id IN (?))) AND c0_.alarm_sent_at IS NOT NULL AND c0_.alarm_sent_at >= ? ORDER BY c0_.alarm_sent_at DESC LIMIT 50 Parameters: [`9 9 "2026-09-01 20:44:38"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.location AS location_3, c0_.ics_uid AS ics_uid_4, c0_.starts_at AS starts_at_5, c0_.ends_at AS ends_at_6, c0_.all_day AS all_day_7, c0_.color AS color_8, c0_.alarm_minutes_before AS alarm_minutes_before_9, c0_.alarm_sent_at AS alarm_sent_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.user_id AS user_id_13 FROM calendar_event c0_ WHERE ( c0_.user_id = ? OR EXISTS ( SELECT 1 FROM calendar_event_share c1_ WHERE c1_.calendar_event_id = c0_.id AND c1_.user_id IN (?) ) ) AND c0_.alarm_sent_at IS NOT NULL AND c0_.alarm_sent_at >= ? ORDER BY c0_.alarm_sent_at DESC LIMIT 50 SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.location AS location_3, c0_.ics_uid AS ics_uid_4, c0_.starts_at AS starts_at_5, c0_.ends_at AS ends_at_6, c0_.all_day AS all_day_7, c0_.color AS color_8, c0_.alarm_minutes_before AS alarm_minutes_before_9, c0_.alarm_sent_at AS alarm_sent_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.user_id AS user_id_13 FROM calendar_event c0_ WHERE (c0_.user_id = 9 OR EXISTS (SELECT 1 FROM calendar_event_share c1_ WHERE c1_.calendar_event_id = c0_.id AND c1_.user_id IN (9))) AND c0_.alarm_sent_at IS NOT NULL AND c0_.alarm_sent_at >= '2026-09-01 20:44:38' ORDER BY c0_.alarm_sent_at DESC LIMIT 50;
21	0.10 ms	SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.status AS status_2, h0_.expected_end_at AS expected_end_at_3, h0_.proposed_clock_out_at AS proposed_clock_out_at_4, h0_.reminder_sent_at AS reminder_sent_at_5, h0_.anomaly_detected_at AS anomaly_detected_at_6, h0_.confirmed_at AS confirmed_at_7, h0_.resolved_at AS resolved_at_8, h0_.notes AS notes_9, h0_.created_at AS created_at_10, h0_.updated_at AS updated_at_11, h0_.tenant_id AS tenant_id_12, h0_.user_id AS user_id_13 FROM hr_day_closure_proposal h0_ WHERE h0_.user_id = ? AND h0_.status IN (?, ?) AND ((h0_.reminder_sent_at IS NOT NULL AND h0_.reminder_sent_at >= ?) OR (h0_.anomaly_detected_at IS NOT NULL AND h0_.anomaly_detected_at >= ?)) ORDER BY h0_.updated_at DESC LIMIT 50 Parameters: [`9 "proposed" "anomaly" "2026-09-01 20:44:38" "2026-09-01 20:44:38"`] View formatted query View runnable query Explain query SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.status AS status_2, h0_.expected_end_at AS expected_end_at_3, h0_.proposed_clock_out_at AS proposed_clock_out_at_4, h0_.reminder_sent_at AS reminder_sent_at_5, h0_.anomaly_detected_at AS anomaly_detected_at_6, h0_.confirmed_at AS confirmed_at_7, h0_.resolved_at AS resolved_at_8, h0_.notes AS notes_9, h0_.created_at AS created_at_10, h0_.updated_at AS updated_at_11, h0_.tenant_id AS tenant_id_12, h0_.user_id AS user_id_13 FROM hr_day_closure_proposal h0_ WHERE h0_.user_id = ? AND h0_.status IN (?, ?) AND ( ( h0_.reminder_sent_at IS NOT NULL AND h0_.reminder_sent_at >= ? ) OR ( h0_.anomaly_detected_at IS NOT NULL AND h0_.anomaly_detected_at >= ? ) ) ORDER BY h0_.updated_at DESC LIMIT 50 SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.status AS status_2, h0_.expected_end_at AS expected_end_at_3, h0_.proposed_clock_out_at AS proposed_clock_out_at_4, h0_.reminder_sent_at AS reminder_sent_at_5, h0_.anomaly_detected_at AS anomaly_detected_at_6, h0_.confirmed_at AS confirmed_at_7, h0_.resolved_at AS resolved_at_8, h0_.notes AS notes_9, h0_.created_at AS created_at_10, h0_.updated_at AS updated_at_11, h0_.tenant_id AS tenant_id_12, h0_.user_id AS user_id_13 FROM hr_day_closure_proposal h0_ WHERE h0_.user_id = 9 AND h0_.status IN ('proposed', 'anomaly') AND ((h0_.reminder_sent_at IS NOT NULL AND h0_.reminder_sent_at >= '2026-09-01 20:44:38') OR (h0_.anomaly_detected_at IS NOT NULL AND h0_.anomaly_detected_at >= '2026-09-01 20:44:38')) ORDER BY h0_.updated_at DESC LIMIT 50;
22	0.09 ms	SELECT h0_.id AS id_0, h0_.type AS type_1, h0_.duration AS duration_2, h0_.start_date AS start_date_3, h0_.end_date AS end_date_4, h0_.hours_minutes AS hours_minutes_5, h0_.start_time AS start_time_6, h0_.end_time AS end_time_7, h0_.status AS status_8, h0_.reason AS reason_9, h0_.decided_at AS decided_at_10, h0_.decision_note AS decision_note_11, h0_.cancellation_reason AS cancellation_reason_12, h0_.cancellation_requested_at AS cancellation_requested_at_13, h0_.created_at AS created_at_14, h0_.updated_at AS updated_at_15, h0_.tenant_id AS tenant_id_16, h0_.user_id AS user_id_17, h0_.decided_by_id AS decided_by_id_18 FROM hr_leave_request h0_ WHERE h0_.user_id = ? AND h0_.status IN (?, ?) AND h0_.decided_at IS NOT NULL AND h0_.decided_at >= ? ORDER BY h0_.decided_at DESC LIMIT 50 Parameters: [`9 "approved" "rejected" "2026-09-01 20:44:38"`] View formatted query View runnable query Explain query SELECT h0_.id AS id_0, h0_.type AS type_1, h0_.duration AS duration_2, h0_.start_date AS start_date_3, h0_.end_date AS end_date_4, h0_.hours_minutes AS hours_minutes_5, h0_.start_time AS start_time_6, h0_.end_time AS end_time_7, h0_.status AS status_8, h0_.reason AS reason_9, h0_.decided_at AS decided_at_10, h0_.decision_note AS decision_note_11, h0_.cancellation_reason AS cancellation_reason_12, h0_.cancellation_requested_at AS cancellation_requested_at_13, h0_.created_at AS created_at_14, h0_.updated_at AS updated_at_15, h0_.tenant_id AS tenant_id_16, h0_.user_id AS user_id_17, h0_.decided_by_id AS decided_by_id_18 FROM hr_leave_request h0_ WHERE h0_.user_id = ? AND h0_.status IN (?, ?) AND h0_.decided_at IS NOT NULL AND h0_.decided_at >= ? ORDER BY h0_.decided_at DESC LIMIT 50 SELECT h0_.id AS id_0, h0_.type AS type_1, h0_.duration AS duration_2, h0_.start_date AS start_date_3, h0_.end_date AS end_date_4, h0_.hours_minutes AS hours_minutes_5, h0_.start_time AS start_time_6, h0_.end_time AS end_time_7, h0_.status AS status_8, h0_.reason AS reason_9, h0_.decided_at AS decided_at_10, h0_.decision_note AS decision_note_11, h0_.cancellation_reason AS cancellation_reason_12, h0_.cancellation_requested_at AS cancellation_requested_at_13, h0_.created_at AS created_at_14, h0_.updated_at AS updated_at_15, h0_.tenant_id AS tenant_id_16, h0_.user_id AS user_id_17, h0_.decided_by_id AS decided_by_id_18 FROM hr_leave_request h0_ WHERE h0_.user_id = 9 AND h0_.status IN ('approved', 'rejected') AND h0_.decided_at IS NOT NULL AND h0_.decided_at >= '2026-09-01 20:44:38' ORDER BY h0_.decided_at DESC LIMIT 50;
23	0.07 ms	SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.minutes AS minutes_2, h0_.expected_minutes AS expected_minutes_3, h0_.worked_minutes AS worked_minutes_4, h0_.status AS status_5, h0_.decided_at AS decided_at_6, h0_.decision_note AS decision_note_7, h0_.created_at AS created_at_8, h0_.updated_at AS updated_at_9, h0_.tenant_id AS tenant_id_10, h0_.user_id AS user_id_11, h0_.decided_by_id AS decided_by_id_12 FROM hr_overtime_record h0_ WHERE h0_.user_id = ? AND h0_.status IN (?, ?) AND h0_.decided_at IS NOT NULL AND h0_.decided_at >= ? ORDER BY h0_.decided_at DESC LIMIT 50 Parameters: [`9 "approved" "rejected" "2026-09-01 20:44:38"`] View formatted query View runnable query Explain query SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.minutes AS minutes_2, h0_.expected_minutes AS expected_minutes_3, h0_.worked_minutes AS worked_minutes_4, h0_.status AS status_5, h0_.decided_at AS decided_at_6, h0_.decision_note AS decision_note_7, h0_.created_at AS created_at_8, h0_.updated_at AS updated_at_9, h0_.tenant_id AS tenant_id_10, h0_.user_id AS user_id_11, h0_.decided_by_id AS decided_by_id_12 FROM hr_overtime_record h0_ WHERE h0_.user_id = ? AND h0_.status IN (?, ?) AND h0_.decided_at IS NOT NULL AND h0_.decided_at >= ? ORDER BY h0_.decided_at DESC LIMIT 50 SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.minutes AS minutes_2, h0_.expected_minutes AS expected_minutes_3, h0_.worked_minutes AS worked_minutes_4, h0_.status AS status_5, h0_.decided_at AS decided_at_6, h0_.decision_note AS decision_note_7, h0_.created_at AS created_at_8, h0_.updated_at AS updated_at_9, h0_.tenant_id AS tenant_id_10, h0_.user_id AS user_id_11, h0_.decided_by_id AS decided_by_id_12 FROM hr_overtime_record h0_ WHERE h0_.user_id = 9 AND h0_.status IN ('approved', 'rejected') AND h0_.decided_at IS NOT NULL AND h0_.decided_at >= '2026-09-01 20:44:38' ORDER BY h0_.decided_at DESC LIMIT 50;
24	0.11 ms	SELECT l0_.id AS id_0, l0_.kind AS kind_1, l0_.first_name AS first_name_2, l0_.last_name AS last_name_3, l0_.company_name AS company_name_4, l0_.tax_code AS tax_code_5, l0_.vat_number AS vat_number_6, l0_.contact_person AS contact_person_7, l0_.phone AS phone_8, l0_.phone_secondary AS phone_secondary_9, l0_.email AS email_10, l0_.pec AS pec_11, l0_.website AS website_12, l0_.other_contacts AS other_contacts_13, l0_.business_category AS business_category_14, l0_.business_type AS business_type_15, l0_.local_units_count AS local_units_count_16, l0_.business_notes AS business_notes_17, l0_.interest_product AS interest_product_18, l0_.potential_products AS potential_products_19, l0_.priority AS priority_20, l0_.notes AS notes_21, l0_.next_action_at AS next_action_at_22, l0_.next_action_label AS next_action_label_23, l0_.last_activity_at AS last_activity_at_24, l0_.converted_at AS converted_at_25, l0_.is_archived AS is_archived_26, l0_.created_at AS created_at_27, l0_.updated_at AS updated_at_28, l0_.tenant_id AS tenant_id_29, l0_.source_id AS source_id_30, l0_.status_id AS status_id_31, l0_.assigned_group_id AS assigned_group_id_32, l0_.assigned_to_id AS assigned_to_id_33, l0_.converted_customer_id AS converted_customer_id_34, l0_.converted_user_id AS converted_user_id_35, l0_.created_by_id AS created_by_id_36 FROM lead l0_ WHERE l0_.is_archived = 0 AND l0_.assigned_to_id = ? AND l0_.next_action_at IS NOT NULL AND l0_.next_action_at < ? AND (l0_.updated_at >= ? OR l0_.next_action_at >= ?) AND l0_.tenant_id = ? ORDER BY l0_.next_action_at ASC LIMIT 100 Parameters: [`9 "2026-09-15 20:44:38" "2026-09-01 20:44:38" "2026-09-01 20:44:38" 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.kind AS kind_1, l0_.first_name AS first_name_2, l0_.last_name AS last_name_3, l0_.company_name AS company_name_4, l0_.tax_code AS tax_code_5, l0_.vat_number AS vat_number_6, l0_.contact_person AS contact_person_7, l0_.phone AS phone_8, l0_.phone_secondary AS phone_secondary_9, l0_.email AS email_10, l0_.pec AS pec_11, l0_.website AS website_12, l0_.other_contacts AS other_contacts_13, l0_.business_category AS business_category_14, l0_.business_type AS business_type_15, l0_.local_units_count AS local_units_count_16, l0_.business_notes AS business_notes_17, l0_.interest_product AS interest_product_18, l0_.potential_products AS potential_products_19, l0_.priority AS priority_20, l0_.notes AS notes_21, l0_.next_action_at AS next_action_at_22, l0_.next_action_label AS next_action_label_23, l0_.last_activity_at AS last_activity_at_24, l0_.converted_at AS converted_at_25, l0_.is_archived AS is_archived_26, l0_.created_at AS created_at_27, l0_.updated_at AS updated_at_28, l0_.tenant_id AS tenant_id_29, l0_.source_id AS source_id_30, l0_.status_id AS status_id_31, l0_.assigned_group_id AS assigned_group_id_32, l0_.assigned_to_id AS assigned_to_id_33, l0_.converted_customer_id AS converted_customer_id_34, l0_.converted_user_id AS converted_user_id_35, l0_.created_by_id AS created_by_id_36 FROM lead l0_ WHERE l0_.is_archived = 0 AND l0_.assigned_to_id = ? AND l0_.next_action_at IS NOT NULL AND l0_.next_action_at < ? AND ( l0_.updated_at >= ? OR l0_.next_action_at >= ? ) AND l0_.tenant_id = ? ORDER BY l0_.next_action_at ASC LIMIT 100 SELECT l0_.id AS id_0, l0_.kind AS kind_1, l0_.first_name AS first_name_2, l0_.last_name AS last_name_3, l0_.company_name AS company_name_4, l0_.tax_code AS tax_code_5, l0_.vat_number AS vat_number_6, l0_.contact_person AS contact_person_7, l0_.phone AS phone_8, l0_.phone_secondary AS phone_secondary_9, l0_.email AS email_10, l0_.pec AS pec_11, l0_.website AS website_12, l0_.other_contacts AS other_contacts_13, l0_.business_category AS business_category_14, l0_.business_type AS business_type_15, l0_.local_units_count AS local_units_count_16, l0_.business_notes AS business_notes_17, l0_.interest_product AS interest_product_18, l0_.potential_products AS potential_products_19, l0_.priority AS priority_20, l0_.notes AS notes_21, l0_.next_action_at AS next_action_at_22, l0_.next_action_label AS next_action_label_23, l0_.last_activity_at AS last_activity_at_24, l0_.converted_at AS converted_at_25, l0_.is_archived AS is_archived_26, l0_.created_at AS created_at_27, l0_.updated_at AS updated_at_28, l0_.tenant_id AS tenant_id_29, l0_.source_id AS source_id_30, l0_.status_id AS status_id_31, l0_.assigned_group_id AS assigned_group_id_32, l0_.assigned_to_id AS assigned_to_id_33, l0_.converted_customer_id AS converted_customer_id_34, l0_.converted_user_id AS converted_user_id_35, l0_.created_by_id AS created_by_id_36 FROM lead l0_ WHERE l0_.is_archived = 0 AND l0_.assigned_to_id = 9 AND l0_.next_action_at IS NOT NULL AND l0_.next_action_at < '2026-09-15 20:44:38' AND (l0_.updated_at >= '2026-09-01 20:44:38' OR l0_.next_action_at >= '2026-09-01 20:44:38') AND l0_.tenant_id = 3 ORDER BY l0_.next_action_at ASC LIMIT 100;
25	0.07 ms	SELECT l0_.id AS id_0, l0_.kind AS kind_1, l0_.first_name AS first_name_2, l0_.last_name AS last_name_3, l0_.company_name AS company_name_4, l0_.tax_code AS tax_code_5, l0_.vat_number AS vat_number_6, l0_.contact_person AS contact_person_7, l0_.phone AS phone_8, l0_.phone_secondary AS phone_secondary_9, l0_.email AS email_10, l0_.pec AS pec_11, l0_.website AS website_12, l0_.other_contacts AS other_contacts_13, l0_.business_category AS business_category_14, l0_.business_type AS business_type_15, l0_.local_units_count AS local_units_count_16, l0_.business_notes AS business_notes_17, l0_.interest_product AS interest_product_18, l0_.potential_products AS potential_products_19, l0_.priority AS priority_20, l0_.notes AS notes_21, l0_.next_action_at AS next_action_at_22, l0_.next_action_label AS next_action_label_23, l0_.last_activity_at AS last_activity_at_24, l0_.converted_at AS converted_at_25, l0_.is_archived AS is_archived_26, l0_.created_at AS created_at_27, l0_.updated_at AS updated_at_28, l0_.tenant_id AS tenant_id_29, l0_.source_id AS source_id_30, l0_.status_id AS status_id_31, l0_.assigned_group_id AS assigned_group_id_32, l0_.assigned_to_id AS assigned_to_id_33, l0_.converted_customer_id AS converted_customer_id_34, l0_.converted_user_id AS converted_user_id_35, l0_.created_by_id AS created_by_id_36 FROM lead l0_ WHERE l0_.is_archived = 0 AND l0_.assigned_to_id = ? AND (l0_.updated_at >= ? OR l0_.created_at >= ?) AND l0_.tenant_id = ? ORDER BY l0_.updated_at DESC LIMIT 100 Parameters: [`9 "2026-09-01 20:44:38" "2026-09-01 20:44:38" 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.kind AS kind_1, l0_.first_name AS first_name_2, l0_.last_name AS last_name_3, l0_.company_name AS company_name_4, l0_.tax_code AS tax_code_5, l0_.vat_number AS vat_number_6, l0_.contact_person AS contact_person_7, l0_.phone AS phone_8, l0_.phone_secondary AS phone_secondary_9, l0_.email AS email_10, l0_.pec AS pec_11, l0_.website AS website_12, l0_.other_contacts AS other_contacts_13, l0_.business_category AS business_category_14, l0_.business_type AS business_type_15, l0_.local_units_count AS local_units_count_16, l0_.business_notes AS business_notes_17, l0_.interest_product AS interest_product_18, l0_.potential_products AS potential_products_19, l0_.priority AS priority_20, l0_.notes AS notes_21, l0_.next_action_at AS next_action_at_22, l0_.next_action_label AS next_action_label_23, l0_.last_activity_at AS last_activity_at_24, l0_.converted_at AS converted_at_25, l0_.is_archived AS is_archived_26, l0_.created_at AS created_at_27, l0_.updated_at AS updated_at_28, l0_.tenant_id AS tenant_id_29, l0_.source_id AS source_id_30, l0_.status_id AS status_id_31, l0_.assigned_group_id AS assigned_group_id_32, l0_.assigned_to_id AS assigned_to_id_33, l0_.converted_customer_id AS converted_customer_id_34, l0_.converted_user_id AS converted_user_id_35, l0_.created_by_id AS created_by_id_36 FROM lead l0_ WHERE l0_.is_archived = 0 AND l0_.assigned_to_id = ? AND ( l0_.updated_at >= ? OR l0_.created_at >= ? ) AND l0_.tenant_id = ? ORDER BY l0_.updated_at DESC LIMIT 100 SELECT l0_.id AS id_0, l0_.kind AS kind_1, l0_.first_name AS first_name_2, l0_.last_name AS last_name_3, l0_.company_name AS company_name_4, l0_.tax_code AS tax_code_5, l0_.vat_number AS vat_number_6, l0_.contact_person AS contact_person_7, l0_.phone AS phone_8, l0_.phone_secondary AS phone_secondary_9, l0_.email AS email_10, l0_.pec AS pec_11, l0_.website AS website_12, l0_.other_contacts AS other_contacts_13, l0_.business_category AS business_category_14, l0_.business_type AS business_type_15, l0_.local_units_count AS local_units_count_16, l0_.business_notes AS business_notes_17, l0_.interest_product AS interest_product_18, l0_.potential_products AS potential_products_19, l0_.priority AS priority_20, l0_.notes AS notes_21, l0_.next_action_at AS next_action_at_22, l0_.next_action_label AS next_action_label_23, l0_.last_activity_at AS last_activity_at_24, l0_.converted_at AS converted_at_25, l0_.is_archived AS is_archived_26, l0_.created_at AS created_at_27, l0_.updated_at AS updated_at_28, l0_.tenant_id AS tenant_id_29, l0_.source_id AS source_id_30, l0_.status_id AS status_id_31, l0_.assigned_group_id AS assigned_group_id_32, l0_.assigned_to_id AS assigned_to_id_33, l0_.converted_customer_id AS converted_customer_id_34, l0_.converted_user_id AS converted_user_id_35, l0_.created_by_id AS created_by_id_36 FROM lead l0_ WHERE l0_.is_archived = 0 AND l0_.assigned_to_id = 9 AND (l0_.updated_at >= '2026-09-01 20:44:38' OR l0_.created_at >= '2026-09-01 20:44:38') AND l0_.tenant_id = 3 ORDER BY l0_.updated_at DESC LIMIT 100;
26	0.06 ms	SELECT m0_.id AS id_0, m0_.source_type AS source_type_1, m0_.source_id AS source_id_2, m0_.context_type AS context_type_3, m0_.context_id AS context_id_4, m0_.excerpt AS excerpt_5, m0_.created_at AS created_at_6, m0_.mentioned_user_id AS mentioned_user_id_7, m0_.created_by_id AS created_by_id_8 FROM mention m0_ WHERE m0_.mentioned_user_id = ? AND m0_.created_at >= ? AND (m0_.created_by_id IS NULL OR m0_.created_by_id <> ?) ORDER BY m0_.created_at DESC, m0_.id DESC LIMIT 100 Parameters: [`9 "2026-09-01 20:44:38" 9`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.source_type AS source_type_1, m0_.source_id AS source_id_2, m0_.context_type AS context_type_3, m0_.context_id AS context_id_4, m0_.excerpt AS excerpt_5, m0_.created_at AS created_at_6, m0_.mentioned_user_id AS mentioned_user_id_7, m0_.created_by_id AS created_by_id_8 FROM mention m0_ WHERE m0_.mentioned_user_id = ? AND m0_.created_at >= ? AND ( m0_.created_by_id IS NULL OR m0_.created_by_id <> ? ) ORDER BY m0_.created_at DESC, m0_.id DESC LIMIT 100 SELECT m0_.id AS id_0, m0_.source_type AS source_type_1, m0_.source_id AS source_id_2, m0_.context_type AS context_type_3, m0_.context_id AS context_id_4, m0_.excerpt AS excerpt_5, m0_.created_at AS created_at_6, m0_.mentioned_user_id AS mentioned_user_id_7, m0_.created_by_id AS created_by_id_8 FROM mention m0_ WHERE m0_.mentioned_user_id = 9 AND m0_.created_at >= '2026-09-01 20:44:38' AND (m0_.created_by_id IS NULL OR m0_.created_by_id <> 9) ORDER BY m0_.created_at DESC, m0_.id DESC LIMIT 100;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\TicketComment	45
App\Entity\InboxMail	26
App\Entity\User	10
App\Entity\Ticket	10
App\Entity\TicketAssignee	7
App\Entity\Company	5
App\Entity\Customer	5
App\Entity\UserMailbox	3
App\Entity\Task	2
App\Entity\Project	2
App\Entity\SupportLevel	2
App\Entity\UserTenant	1
App\Entity\Tenant	1
App\Entity\PlatformMailbox	1
App\Entity\HrLeaveRequest	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Project	No errors.
App\Entity\Task	No errors.
App\Entity\Comment	No errors.
App\Entity\UserEmail	No errors.
App\Entity\UserMailbox	No errors.
App\Entity\SupportLevel	No errors.
App\Entity\UserTenant	No errors.
App\Entity\Tenant	No errors.
App\Entity\UserNotificationRead	No errors.
App\Entity\PlatformMailbox	No errors.
App\Entity\InboxMail	No errors.
App\Entity\InboxMailUserRead	No errors.
App\Entity\InboxMailAttachment	No errors.
App\Entity\FileAttachment	No errors.
App\Entity\TaskInvitation	No errors.
App\Entity\TicketAssignee	No errors.
App\Entity\Ticket	No errors.
App\Entity\Customer	No errors.
App\Entity\Supplier	No errors.
App\Entity\CatalogProduct	No errors.
App\Entity\WidgetSite	No errors.
App\Entity\TicketTemplate	No errors.
App\Entity\SupplierContact	No errors.
App\Entity\TicketComment	No errors.
App\Entity\TicketStep	No errors.
App\Entity\CompanyLocalUnit	No errors.
App\Entity\CatalogCustomerProduct	No errors.
App\Entity\TicketUserRead	No errors.
App\Entity\CalendarEvent	No errors.
App\Entity\HrDayClosureProposal	No errors.
App\Entity\HrLeaveRequest	No errors.
App\Entity\HrOvertimeRecord	No errors.
App\Entity\Lead	No errors.
App\Entity\LeadSource	No errors.
App\Entity\LeadStatus	No errors.
App\Entity\Mention	No errors.

Symfony Profiler

GET https://nexiodesk.net/notifications?count=1

Configuration Settings

Theme

Page Width