Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.domain AS domain_1,
  m0_.base_path AS base_path_2,
  m0_.is_active AS is_active_3,
  m0_.ssl_enabled AS ssl_enabled_4,
  m0_.verification_token AS verification_token_5,
  m0_.is_verified AS is_verified_6,
  m0_.verified_at AS verified_at_7,
  m0_.notes AS notes_8,
  m0_.created_at AS created_at_9,
  m0_.updated_at AS updated_at_10,
  m0_.tenant_id AS tenant_id_11,
  m0_.mobile_app_id AS mobile_app_id_12,
  m0_.registry_id AS registry_id_13
FROM
  mobile_app_domain m0_
WHERE
  m0_.domain = ?
  AND (
    (
      m0_.base_path = ?
      OR m0_.base_path IS NULL
    )
  )
  AND m0_.is_active = ?

SELECT m0_.id AS id_0, m0_.domain AS domain_1, m0_.base_path AS base_path_2, m0_.is_active AS is_active_3, m0_.ssl_enabled AS ssl_enabled_4, m0_.verification_token AS verification_token_5, m0_.is_verified AS is_verified_6, m0_.verified_at AS verified_at_7, m0_.notes AS notes_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.tenant_id AS tenant_id_11, m0_.mobile_app_id AS mobile_app_id_12, m0_.registry_id AS registry_id_13 FROM mobile_app_domain m0_ WHERE m0_.domain = 'dev.evolvepreneuriq.app' AND ((m0_.base_path = '' OR m0_.base_path IS NULL)) AND m0_.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.totp_secret AS totp_secret_5,
  t0.totp_enabled AS totp_enabled_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.theme AS theme_9,
  t0.profile_image AS profile_image_10,
  t0.preferences AS preferences_11,
  t0.timezone AS timezone_12,
  t0.status AS status_13,
  t0.external_id AS external_id_14,
  t0.phone AS phone_15,
  t0.mobile_phone AS mobile_phone_16,
  t0.business_name AS business_name_17,
  t0.city AS city_18,
  t0.country AS country_19,
  t0.postcode AS postcode_20,
  t0.state AS state_21,
  t0.suburb AS suburb_22,
  t0.website AS website_23,
  t0.biography AS biography_24,
  t0.gender AS gender_25,
  t0.locale AS locale_26,
  t0.date_of_birth AS date_of_birth_27,
  t0.last_login_at AS last_login_at_28,
  t0.is_enabled AS is_enabled_29,
  t0.social_links AS social_links_30,
  t0.terms_agreed AS terms_agreed_31,
  t0.terms_agreed_at AS terms_agreed_at_32,
  t0.terms_version AS terms_version_33,
  t0.email_consent AS email_consent_34,
  t0.email_consent_at AS email_consent_at_35,
  t0.registration_ip AS registration_ip_36,
  t0.registered_at AS registered_at_37,
  t0.is_archived AS is_archived_38,
  t0.archived_at AS archived_at_39,
  t0.archived_reason AS archived_reason_40,
  t0.tenant_id AS tenant_id_41,
  t0.default_tenant_id AS default_tenant_id_42
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.totp_secret AS totp_secret_5, t0.totp_enabled AS totp_enabled_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.theme AS theme_9, t0.profile_image AS profile_image_10, t0.preferences AS preferences_11, t0.timezone AS timezone_12, t0.status AS status_13, t0.external_id AS external_id_14, t0.phone AS phone_15, t0.mobile_phone AS mobile_phone_16, t0.business_name AS business_name_17, t0.city AS city_18, t0.country AS country_19, t0.postcode AS postcode_20, t0.state AS state_21, t0.suburb AS suburb_22, t0.website AS website_23, t0.biography AS biography_24, t0.gender AS gender_25, t0.locale AS locale_26, t0.date_of_birth AS date_of_birth_27, t0.last_login_at AS last_login_at_28, t0.is_enabled AS is_enabled_29, t0.social_links AS social_links_30, t0.terms_agreed AS terms_agreed_31, t0.terms_agreed_at AS terms_agreed_at_32, t0.terms_version AS terms_version_33, t0.email_consent AS email_consent_34, t0.email_consent_at AS email_consent_at_35, t0.registration_ip AS registration_ip_36, t0.registered_at AS registered_at_37, t0.is_archived AS is_archived_38, t0.archived_at AS archived_at_39, t0.archived_reason AS archived_reason_40, t0.tenant_id AS tenant_id_41, t0.default_tenant_id AS default_tenant_id_42 FROM "user" t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_active AS is_active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.cdn_storage_used_bytes AS cdn_storage_used_bytes_7,
  t0.cdn_file_count AS cdn_file_count_8,
  t0.cdn_storage_quota_bytes AS cdn_storage_quota_bytes_9,
  t0.db_storage_used_bytes AS db_storage_used_bytes_10,
  t0.storage_updated_at AS storage_updated_at_11,
  t0.owner_id AS owner_id_12,
  t13.id AS id_14,
  t13.logo_path AS logo_path_15,
  t13.logo_light_path AS logo_light_path_16,
  t13.logo_dark_path AS logo_dark_path_17,
  t13.logo_square_path AS logo_square_path_18,
  t13.favicon_path AS favicon_path_19,
  t13.primary_color AS primary_color_20,
  t13.secondary_color AS secondary_color_21,
  t13.accent_color AS accent_color_22,
  t13.timezone AS timezone_23,
  t13.currency AS currency_24,
  t13.locale AS locale_25,
  t13.date_format AS date_format_26,
  t13.time_format AS time_format_27,
  t13.company_name AS company_name_28,
  t13.app_name AS app_name_29,
  t13.support_email AS support_email_30,
  t13.support_phone AS support_phone_31,
  t13.website_url AS website_url_32,
  t13.address AS address_33,
  t13.show_powered_by AS show_powered_by_34,
  t13.custom_footer_text AS custom_footer_text_35,
  t13.login_message AS login_message_36,
  t13.welcome_message AS welcome_message_37,
  t13.ai_provider_preference AS ai_provider_preference_38,
  t13.ai_action_routing AS ai_action_routing_39,
  t13.base_system_prompt AS base_system_prompt_40,
  t13.behavior_rules AS behavior_rules_41,
  t13.bug_auto_assign AS bug_auto_assign_42,
  t13.rc_files_cdn_url AS rc_files_cdn_url_43,
  t13.rc_files_cdn_config AS rc_files_cdn_config_44,
  t13.media_studio_budget AS media_studio_budget_45,
  t13.video_auto_transcribe AS video_auto_transcribe_46,
  t13.podcast_auto_transcribe AS podcast_auto_transcribe_47,
  t13.transactional_email_provider AS transactional_email_provider_48,
  t13.marketing_email_provider AS marketing_email_provider_49,
  t13.created_at AS created_at_50,
  t13.updated_at AS updated_at_51,
  t13.tenant_id AS tenant_id_52,
  t13.default_bug_admin_id AS default_bug_admin_id_53
FROM
  tenants t0
  LEFT JOIN tenant_settings t13 ON t13.tenant_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.cdn_storage_used_bytes AS cdn_storage_used_bytes_7, t0.cdn_file_count AS cdn_file_count_8, t0.cdn_storage_quota_bytes AS cdn_storage_quota_bytes_9, t0.db_storage_used_bytes AS db_storage_used_bytes_10, t0.storage_updated_at AS storage_updated_at_11, t0.owner_id AS owner_id_12, t13.id AS id_14, t13.logo_path AS logo_path_15, t13.logo_light_path AS logo_light_path_16, t13.logo_dark_path AS logo_dark_path_17, t13.logo_square_path AS logo_square_path_18, t13.favicon_path AS favicon_path_19, t13.primary_color AS primary_color_20, t13.secondary_color AS secondary_color_21, t13.accent_color AS accent_color_22, t13.timezone AS timezone_23, t13.currency AS currency_24, t13.locale AS locale_25, t13.date_format AS date_format_26, t13.time_format AS time_format_27, t13.company_name AS company_name_28, t13.app_name AS app_name_29, t13.support_email AS support_email_30, t13.support_phone AS support_phone_31, t13.website_url AS website_url_32, t13.address AS address_33, t13.show_powered_by AS show_powered_by_34, t13.custom_footer_text AS custom_footer_text_35, t13.login_message AS login_message_36, t13.welcome_message AS welcome_message_37, t13.ai_provider_preference AS ai_provider_preference_38, t13.ai_action_routing AS ai_action_routing_39, t13.base_system_prompt AS base_system_prompt_40, t13.behavior_rules AS behavior_rules_41, t13.bug_auto_assign AS bug_auto_assign_42, t13.rc_files_cdn_url AS rc_files_cdn_url_43, t13.rc_files_cdn_config AS rc_files_cdn_config_44, t13.media_studio_budget AS media_studio_budget_45, t13.video_auto_transcribe AS video_auto_transcribe_46, t13.podcast_auto_transcribe AS podcast_auto_transcribe_47, t13.transactional_email_provider AS transactional_email_provider_48, t13.marketing_email_provider AS marketing_email_provider_49, t13.created_at AS created_at_50, t13.updated_at AS updated_at_51, t13.tenant_id AS tenant_id_52, t13.default_bug_admin_id AS default_bug_admin_id_53 FROM tenants t0 LEFT JOIN tenant_settings t13 ON t13.tenant_id = t0.id WHERE t0.id = 1;

SELECT
  u0_.id AS id_0,
  u0_.is_active AS is_active_1,
  u0_.assigned_at AS assigned_at_2,
  u0_.notes AS notes_3,
  u0_.expires_at AS expires_at_4,
  u0_.tenant_id AS tenant_id_5,
  u0_.user_id AS user_id_6,
  u0_.profile_id AS profile_id_7,
  u0_.assigned_by_id AS assigned_by_id_8
FROM
  user_dashboard_assignments u0_
WHERE
  (
    u0_.user_id = ?
    AND u0_.is_active = true
    AND (
      u0_.expires_at IS NULL
      OR u0_.expires_at > ?
    )
    AND u0_.tenant_id = ?
  )
  AND (u0_.tenant_id = '1')
ORDER BY
  u0_.assigned_at DESC
LIMIT
  1

SELECT u0_.id AS id_0, u0_.is_active AS is_active_1, u0_.assigned_at AS assigned_at_2, u0_.notes AS notes_3, u0_.expires_at AS expires_at_4, u0_.tenant_id AS tenant_id_5, u0_.user_id AS user_id_6, u0_.profile_id AS profile_id_7, u0_.assigned_by_id AS assigned_by_id_8 FROM user_dashboard_assignments u0_ WHERE (u0_.user_id = 1 AND u0_.is_active = true AND (u0_.expires_at IS NULL OR u0_.expires_at > '2026-04-18 13:41:28') AND u0_.tenant_id = 1) AND (u0_.tenant_id = '1') ORDER BY u0_.assigned_at DESC LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2,
  d0_.description AS description_3,
  d0_.landing_route AS landing_route_4,
  d0_.landing_url AS landing_url_5,
  d0_.show_sidebar AS show_sidebar_6,
  d0_.allowed_routes AS allowed_routes_7,
  d0_.denied_routes AS denied_routes_8,
  d0_.theme_config AS theme_config_9,
  d0_.settings AS settings_10,
  d0_.is_default AS is_default_11,
  d0_.is_active AS is_active_12,
  d0_.created_at AS created_at_13,
  d0_.updated_at AS updated_at_14,
  d0_.tenant_id AS tenant_id_15,
  d0_.sidebar_menu_id AS sidebar_menu_id_16,
  d0_.header_menu_id AS header_menu_id_17,
  d0_.default_dashboard_id AS default_dashboard_id_18
FROM
  dashboard_profiles d0_
WHERE
  (
    d0_.tenant_id = ?
    AND d0_.is_default = true
    AND d0_.is_active = true
  )
  AND (d0_.tenant_id = '1')
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2, d0_.description AS description_3, d0_.landing_route AS landing_route_4, d0_.landing_url AS landing_url_5, d0_.show_sidebar AS show_sidebar_6, d0_.allowed_routes AS allowed_routes_7, d0_.denied_routes AS denied_routes_8, d0_.theme_config AS theme_config_9, d0_.settings AS settings_10, d0_.is_default AS is_default_11, d0_.is_active AS is_active_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, d0_.tenant_id AS tenant_id_15, d0_.sidebar_menu_id AS sidebar_menu_id_16, d0_.header_menu_id AS header_menu_id_17, d0_.default_dashboard_id AS default_dashboard_id_18 FROM dashboard_profiles d0_ WHERE (d0_.tenant_id = 1 AND d0_.is_default = true AND d0_.is_active = true) AND (d0_.tenant_id = '1') LIMIT 1;

UPDATE
  tenant_users
SET
  last_active_at = NOW()
WHERE
  tenant_id = ?
  AND user_id = ?

UPDATE tenant_users SET last_active_at = NOW() WHERE tenant_id = 1 AND user_id = 1;

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notification n0_
WHERE
  (
    n0_.user_id = ?
    AND n0_.seen = false
  )
  AND (n0_.tenant_id = '1')

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE (n0_.user_id = 1 AND n0_.seen = false) AND (n0_.tenant_id = '1');