Symfony Profiler

[
  "route" => "_api_/workspaces{._format}_get_collection"
  "route_parameters" => [
    "_route" => "_api_/workspaces{._format}_get_collection"
    "_controller" => "api_platform.action.placeholder"
    "_stateless" => null
    "_api_resource_class" => "App\Domain\Workspace\Entity\Workspace"
    "_api_operation_name" => "_api_/workspaces{._format}_get_collection"
    "_format" => null
  ]
  "request_uri" => "http://api.sublimanalytics.com/api/workspaces"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => null
    "user" => "postgres"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "sublim_prod"
    "serverVersion" => "13"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.type AS type_5, t0.is_verified AS is_verified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.last_login AS last_login_9, t0.phone AS phone_10, t0.enabled AS enabled_11, t0.avatar AS avatar_12, t0.deleted_at AS deleted_at_13, t0.banned_at AS banned_at_14, t0.token AS token_15, t0.snippet_email_sent_at AS snippet_email_sent_at_16, t0.totp_secret AS totp_secret_17, t0.is_two_factor_enabled AS is_two_factor_enabled_18, t0.backup_codes AS backup_codes_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.discord_id AS discord_id_22, t0.github_id AS github_id_23, t0.google_id AS google_id_24, t0.facebook_id AS facebook_id_25, t0.apple_id AS apple_id_26, t0.invited_by_id AS invited_by_id_27, t0.company_id AS company_id_28, t0.last_selected_project_id AS last_selected_project_id_29 FROM auth_user t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "support@sublimanalytics.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1480
      +name: "STRING"
    }
  ]
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#1536
    -user: App\Domain\Auth\Entity\User {#1494 …}
    -roleNames: [
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NzQ1NDY3MDQsImV4cCI6MTc4MzE4NjcwNCwicm9sZXMiOlsiUk9MRV9VU0VSIl0sInVzZXJuYW1lIjoic3VwcG9ydEBzdWJsaW1hbmFseXRpY3MuY29tIn0.grElWCB0KbqXoEzp1Cw74PSNR3QGT4NuWsHuEm3WaQc9ayib2unSyppIpFGEVqUgNvDaQI0RCU0X_uFPAsQhpBmEBhvk1aSIj6mVy-Cm_W2w5N5LpI_Spit1rKltr3B6A5ipicFA9LRoCkCTVgt1tBYhPW6zqa89DtgHql8l7xZduAKihAB7_rPscVaRFCZjXJvPlUQuwXxHPRuvBqvscVMwAZ6oADu9JaOB-tQyz3O2asdaeGIqyTYprof5vPZbX_Rk1TWsziqvXPk8fVom6uBNklbOoq3VJktAS4acV9ypwhUAhUWxf4jCAP_ngigpNqXP0XiOVYbKO5iQ07gKww"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "sql" => "SELECT count(DISTINCT w0_.id) AS sclr_0 FROM workspace_workspace w0_ LEFT JOIN billing_company b1_ ON w0_.company_id = b1_.id LEFT JOIN project_project p2_ ON w0_.id = p2_.workspace_id WHERE w0_.id IN (SELECT p3_.workspace_id AS sclr_1 FROM project_project_member p4_ INNER JOIN project_project p3_ ON p4_.project_id = p3_.id WHERE p4_.user_id = ?)"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1479
      #uid: "019d2b39-d44e-7a46-b6c6-5ddbbeb204b6"
      toBase58: "1CZS6iB4rjWgWZojbkak1K"
      toBase32: "01KMNKKN2EF93BDHJXVEZB415P"
      time: "2026-03-26 17:38:23.438657 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1480
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT w0_.id AS id_0, w0_.id AS id_1 FROM workspace_workspace w0_ LEFT JOIN billing_company b1_ ON w0_.company_id = b1_.id LEFT JOIN project_project p2_ ON w0_.id = p2_.workspace_id WHERE w0_.id IN (SELECT p3_.workspace_id AS sclr_2 FROM project_project_member p4_ INNER JOIN project_project p3_ ON p4_.project_id = p3_.id WHERE p4_.user_id = ?) ORDER BY w0_.id ASC LIMIT 30"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1479
      #uid: "019d2b39-d44e-7a46-b6c6-5ddbbeb204b6"
      toBase58: "1CZS6iB4rjWgWZojbkak1K"
      toBase32: "01KMNKKN2EF93BDHJXVEZB415P"
      time: "2026-03-26 17:38:23.438657 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1480
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.description AS description_2, w0_.logo AS logo_3, w0_.timezone AS timezone_4, w0_.currency AS currency_5, w0_.language AS language_6, w0_.deleted_at AS deleted_at_7, w0_.created_at AS created_at_8, w0_.updated_at AS updated_at_9, b1_.id AS id_10, b1_.name AS name_11, b1_.address_line1 AS address_line1_12, b1_.address_line2 AS address_line2_13, b1_.postal_code AS postal_code_14, b1_.city AS city_15, b1_.country AS country_16, b1_.vat_number AS vat_number_17, b1_.stripe_customer_id AS stripe_customer_id_18, b1_.stripe_subscription_id AS stripe_subscription_id_19, b1_.stripe_price_id AS stripe_price_id_20, b1_.subscription_status AS subscription_status_21, b1_.trial_ends_at AS trial_ends_at_22, b1_.plan_slug AS plan_slug_23, b1_.plan_tier AS plan_tier_24, b1_.billing_cycle AS billing_cycle_25, b1_.max_projects AS max_projects_26, b1_.max_team_members AS max_team_members_27, b1_.insights_credits AS insights_credits_28, b1_.cancellation_reason AS cancellation_reason_29, b1_.cancellation_comment AS cancellation_comment_30, b1_.cancelled_at AS cancelled_at_31, b1_.cancels_at AS cancels_at_32, b1_.retention_discount_used_at AS retention_discount_used_at_33, b1_.current_projects AS current_projects_34, b1_.current_team_members AS current_team_members_35, b1_.used_insights_credits AS used_insights_credits_36, b1_.extra_sites AS extra_sites_37, b1_.extra_users AS extra_users_38, b1_.extra_insights AS extra_insights_39, b1_.remove_logo AS remove_logo_40, b1_.welcome_modal_seen AS welcome_modal_seen_41, b1_.discovery_sources AS discovery_sources_42, b1_.created_at AS created_at_43, b1_.updated_at AS updated_at_44, p2_.id AS id_45, p2_.name AS name_46, p2_.description AS description_47, p2_.url AS url_48, p2_.identifier AS identifier_49, p2_.custom_business_type AS custom_business_type_50, p2_.deleted_at AS deleted_at_51, p2_.current_month_page_views AS current_month_page_views_52, p2_.created_at AS created_at_53, p2_.updated_at AS updated_at_54, p2_.geographic_scope AS geographic_scope_55, p2_.cities AS cities_56, p2_.regions AS regions_57, p2_.countries AS countries_58, p2_.markets AS markets_59, p2_.settings_excluded_ips AS settings_excluded_ips_60, p2_.settings_excluded_paths AS settings_excluded_paths_61, p2_.settings_excluded_hostnames AS settings_excluded_hostnames_62, p2_.settings_excluded_countries AS settings_excluded_countries_63, p2_.crawler_settings_page_limit AS crawler_settings_page_limit_64, p2_.crawler_settings_schedule AS crawler_settings_schedule_65, p2_.crawler_settings_schedule_days AS crawler_settings_schedule_days_66, p2_.crawler_settings_user_agent AS crawler_settings_user_agent_67, p2_.crawler_settings_crawl_delay AS crawler_settings_crawl_delay_68, p2_.crawler_settings_respect_robots AS crawler_settings_respect_robots_69, p2_.crawler_settings_js_rendering AS crawler_settings_js_rendering_70, p2_.crawler_settings_url_patterns AS crawler_settings_url_patterns_71, w0_.company_id AS company_id_72, p2_.workspace_id AS workspace_id_73, p2_.business_type_id AS business_type_id_74 FROM workspace_workspace w0_ LEFT JOIN billing_company b1_ ON w0_.company_id = b1_.id LEFT JOIN project_project p2_ ON w0_.id = p2_.workspace_id WHERE w0_.id IN (SELECT p3_.workspace_id AS sclr_75 FROM project_project_member p4_ INNER JOIN project_project p3_ ON p4_.project_id = p3_.id WHERE p4_.user_id = ?) AND w0_.id IN (?) ORDER BY w0_.id ASC"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1479
      #uid: "019d2b39-d44e-7a46-b6c6-5ddbbeb204b6"
      toBase58: "1CZS6iB4rjWgWZojbkak1K"
      toBase32: "01KMNKKN2EF93BDHJXVEZB415P"
      time: "2026-03-26 17:38:23.438657 UTC"
    }
    2 => "019d2b39-fd69-70f5-a2a8-a3eb4aee8121"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1480
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1480}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.summary AS summary_3, t0.industry AS industry_4, t0.business_model AS business_model_5, t0.target_audience AS target_audience_6, t0.primary_language AS primary_language_7, t0.geographic_focus AS geographic_focus_8, t0.market_countries AS market_countries_9, t0.main_services AS main_services_10, t0.brand_voice AS brand_voice_11, t0.value_proposition AS value_proposition_12, t0.has_blog AS has_blog_13, t0.has_ecommerce AS has_ecommerce_14, t0.has_multilingual AS has_multilingual_15, t0.technology_stack AS technology_stack_16, t0.social_profiles AS social_profiles_17, t0.keywords AS keywords_18, t0.pages_crawled AS pages_crawled_19, t0.analyzed_at AS analyzed_at_20, t0.error_message AS error_message_21, t0.dispatched_at AS dispatched_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.project_id AS project_id_25 FROM project_context t0 WHERE t0.project_id = ?"
  "params" => [
    1 => "019d2b39-fe37-7542-b1f5-b24fc37e5c0e"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1480
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.project_id AS project_id_5, t0.user_id AS user_id_6 FROM project_project_member t0 WHERE t0.project_id = ?"
  "params" => [
    1 => "019d2b39-fe37-7542-b1f5-b24fc37e5c0e"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1480
      +name: "STRING"
    }
  ]
]