GET http://api.sublimanalytics.com/api/workspaces

Query Metrics

6 Database Queries
6 Different statements
12.20 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 2.22 ms
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
Parameters:
[
  "support@sublimanalytics.com"
]
2 4.67 ms
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 = ?)
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1479
    __toString(): "019d2b39-d44e-7a46-b6c6-5ddbbeb204b6"
  }
]
3 2.75 ms
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
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1479
    __toString(): "019d2b39-d44e-7a46-b6c6-5ddbbeb204b6"
  }
]
4 1.52 ms
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
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1479
    __toString(): "019d2b39-d44e-7a46-b6c6-5ddbbeb204b6"
  }
  "019d2b39-fd69-70f5-a2a8-a3eb4aee8121"
]
5 0.67 ms
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 = ?
Parameters:
[
  "019d2b39-fe37-7542-b1f5-b24fc37e5c0e"
]
6 0.37 ms
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 = ?
Parameters:
[
  "019d2b39-fe37-7542-b1f5-b24fc37e5c0e"
]

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\Domain\Auth\Entity\User 1
App\Domain\Billing\Entity\Company 1
App\Domain\Workspace\Entity\Workspace 1
App\Domain\Project\Entity\Project 1
App\Domain\Project\Entity\ProjectContext 1
App\Domain\Project\Entity\ProjectMember 1