| 1 |
2.89 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"
]
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 = 'support@sublimanalytics.com' LIMIT 1;
|
| 4 |
1.37 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
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
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 = '019d2b39-d44e-7a46-b6c6-5ddbbeb204b6') AND w0_.id IN ('019d2b39-fd69-70f5-a2a8-a3eb4aee8121') ORDER BY w0_.id ASC;
|
| 5 |
0.75 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"
]
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 = '019d2b39-fe37-7542-b1f5-b24fc37e5c0e';
|