| 1 |
0.80 ms |
SELECT t0.id AS id_1, t0.enable_cdn AS enable_cdn_2, t0.cdn_endpoint AS cdn_endpoint_3, t0.cdn_access_key AS cdn_access_key_4, t0.cdn_secret_key AS cdn_secret_key_5, t0.cdn_bucket AS cdn_bucket_6, t0.cdn_region AS cdn_region_7, t0.cdn_public_url AS cdn_public_url_8, t0.backups_bucket AS backups_bucket_9, t0.backup_retention_days AS backup_retention_days_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.app_settings_id AS app_settings_id_13 FROM app_settings_cdn t0 LIMIT 1
SELECT t0.id AS id_1, t0.enable_cdn AS enable_cdn_2, t0.cdn_endpoint AS cdn_endpoint_3, t0.cdn_access_key AS cdn_access_key_4, t0.cdn_secret_key AS cdn_secret_key_5, t0.cdn_bucket AS cdn_bucket_6, t0.cdn_region AS cdn_region_7, t0.cdn_public_url AS cdn_public_url_8, t0.backups_bucket AS backups_bucket_9, t0.backup_retention_days AS backup_retention_days_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.app_settings_id AS app_settings_id_13 FROM app_settings_cdn t0 LIMIT 1;
|
| 2 |
1.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = ? AND t0.provider = ? AND t0.enabled = ? LIMIT 1
Parameters: [
"ai"
"anthropic"
1
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = 'ai' AND t0.provider = 'anthropic' AND t0.enabled = 1 LIMIT 1;
|
| 3 |
0.80 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = ? AND t0.provider = ? AND t0.enabled = ? LIMIT 1
Parameters: [
"ai"
"openai"
1
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = 'ai' AND t0.provider = 'openai' AND t0.enabled = 1 LIMIT 1;
|
| 4 |
1.35 ms |
SELECT a0_.id AS id_0, a0_.app_name AS app_name_1, a0_.public_url AS public_url_2, a0_.support_email AS support_email_3, a0_.app_description AS app_description_4, a0_.favicon_path AS favicon_path_5, a0_.logo_path AS logo_path_6, a0_.login_background_image AS login_background_image_7, a0_.footer_text AS footer_text_8, a0_.maintenance_message AS maintenance_message_9, a0_.company_name AS company_name_10, a0_.company_address AS company_address_11, a0_.company_phone AS company_phone_12, a0_.company_website AS company_website_13, a0_.company_email AS company_email_14, a0_.currency AS currency_15, a0_.timezone AS timezone_16, a0_.bug_auto_assignment_enabled AS bug_auto_assignment_enabled_17, a0_.bug_review_reassignment_enabled AS bug_review_reassignment_enabled_18, a0_.mcp_introspection_secret AS mcp_introspection_secret_19, a0_.created_at AS created_at_20, a0_.updated_at AS updated_at_21, a1_.id AS id_22, a1_.enable_matomo AS enable_matomo_23, a1_.matomo_site_url AS matomo_site_url_24, a1_.matomo_site_id AS matomo_site_id_25, a1_.enable_google_analytics AS enable_google_analytics_26, a1_.google_analytics_id AS google_analytics_id_27, a1_.custom_head_scripts AS custom_head_scripts_28, a1_.custom_body_scripts AS custom_body_scripts_29, a1_.meta_title AS meta_title_30, a1_.meta_description AS meta_description_31, a1_.meta_keywords AS meta_keywords_32, a1_.created_at AS created_at_33, a1_.updated_at AS updated_at_34, a2_.id AS id_35, a2_.enable_cdn AS enable_cdn_36, a2_.cdn_endpoint AS cdn_endpoint_37, a2_.cdn_access_key AS cdn_access_key_38, a2_.cdn_secret_key AS cdn_secret_key_39, a2_.cdn_bucket AS cdn_bucket_40, a2_.cdn_region AS cdn_region_41, a2_.cdn_public_url AS cdn_public_url_42, a2_.backups_bucket AS backups_bucket_43, a2_.backup_retention_days AS backup_retention_days_44, a2_.created_at AS created_at_45, a2_.updated_at AS updated_at_46, a3_.id AS id_47, a3_.theme AS theme_48, a3_.primary_color AS primary_color_49, a3_.secondary_color AS secondary_color_50, a3_.debug_mode AS debug_mode_51, a3_.allow_registration AS allow_registration_52, a3_.require_email_verification AS require_email_verification_53, a3_.session_timeout AS session_timeout_54, a3_.maintenance_mode AS maintenance_mode_55, a3_.created_at AS created_at_56, a3_.updated_at AS updated_at_57, a0_.default_bug_assignee_id AS default_bug_assignee_id_58, a1_.app_settings_id AS app_settings_id_59, a2_.app_settings_id AS app_settings_id_60, a3_.app_settings_id AS app_settings_id_61 FROM app_settings a0_ LEFT JOIN app_settings_analytics a1_ ON a0_.id = a1_.app_settings_id LEFT JOIN app_settings_cdn a2_ ON a0_.id = a2_.app_settings_id LEFT JOIN app_settings_system a3_ ON a0_.id = a3_.app_settings_id LIMIT 1
SELECT
a0_.id AS id_0,
a0_.app_name AS app_name_1,
a0_.public_url AS public_url_2,
a0_.support_email AS support_email_3,
a0_.app_description AS app_description_4,
a0_.favicon_path AS favicon_path_5,
a0_.logo_path AS logo_path_6,
a0_.login_background_image AS login_background_image_7,
a0_.footer_text AS footer_text_8,
a0_.maintenance_message AS maintenance_message_9,
a0_.company_name AS company_name_10,
a0_.company_address AS company_address_11,
a0_.company_phone AS company_phone_12,
a0_.company_website AS company_website_13,
a0_.company_email AS company_email_14,
a0_.currency AS currency_15,
a0_.timezone AS timezone_16,
a0_.bug_auto_assignment_enabled AS bug_auto_assignment_enabled_17,
a0_.bug_review_reassignment_enabled AS bug_review_reassignment_enabled_18,
a0_.mcp_introspection_secret AS mcp_introspection_secret_19,
a0_.created_at AS created_at_20,
a0_.updated_at AS updated_at_21,
a1_.id AS id_22,
a1_.enable_matomo AS enable_matomo_23,
a1_.matomo_site_url AS matomo_site_url_24,
a1_.matomo_site_id AS matomo_site_id_25,
a1_.enable_google_analytics AS enable_google_analytics_26,
a1_.google_analytics_id AS google_analytics_id_27,
a1_.custom_head_scripts AS custom_head_scripts_28,
a1_.custom_body_scripts AS custom_body_scripts_29,
a1_.meta_title AS meta_title_30,
a1_.meta_description AS meta_description_31,
a1_.meta_keywords AS meta_keywords_32,
a1_.created_at AS created_at_33,
a1_.updated_at AS updated_at_34,
a2_.id AS id_35,
a2_.enable_cdn AS enable_cdn_36,
a2_.cdn_endpoint AS cdn_endpoint_37,
a2_.cdn_access_key AS cdn_access_key_38,
a2_.cdn_secret_key AS cdn_secret_key_39,
a2_.cdn_bucket AS cdn_bucket_40,
a2_.cdn_region AS cdn_region_41,
a2_.cdn_public_url AS cdn_public_url_42,
a2_.backups_bucket AS backups_bucket_43,
a2_.backup_retention_days AS backup_retention_days_44,
a2_.created_at AS created_at_45,
a2_.updated_at AS updated_at_46,
a3_.id AS id_47,
a3_.theme AS theme_48,
a3_.primary_color AS primary_color_49,
a3_.secondary_color AS secondary_color_50,
a3_.debug_mode AS debug_mode_51,
a3_.allow_registration AS allow_registration_52,
a3_.require_email_verification AS require_email_verification_53,
a3_.session_timeout AS session_timeout_54,
a3_.maintenance_mode AS maintenance_mode_55,
a3_.created_at AS created_at_56,
a3_.updated_at AS updated_at_57,
a0_.default_bug_assignee_id AS default_bug_assignee_id_58,
a1_.app_settings_id AS app_settings_id_59,
a2_.app_settings_id AS app_settings_id_60,
a3_.app_settings_id AS app_settings_id_61
FROM
app_settings a0_
LEFT JOIN app_settings_analytics a1_ ON a0_.id = a1_.app_settings_id
LEFT JOIN app_settings_cdn a2_ ON a0_.id = a2_.app_settings_id
LEFT JOIN app_settings_system a3_ ON a0_.id = a3_.app_settings_id
LIMIT
1
SELECT a0_.id AS id_0, a0_.app_name AS app_name_1, a0_.public_url AS public_url_2, a0_.support_email AS support_email_3, a0_.app_description AS app_description_4, a0_.favicon_path AS favicon_path_5, a0_.logo_path AS logo_path_6, a0_.login_background_image AS login_background_image_7, a0_.footer_text AS footer_text_8, a0_.maintenance_message AS maintenance_message_9, a0_.company_name AS company_name_10, a0_.company_address AS company_address_11, a0_.company_phone AS company_phone_12, a0_.company_website AS company_website_13, a0_.company_email AS company_email_14, a0_.currency AS currency_15, a0_.timezone AS timezone_16, a0_.bug_auto_assignment_enabled AS bug_auto_assignment_enabled_17, a0_.bug_review_reassignment_enabled AS bug_review_reassignment_enabled_18, a0_.mcp_introspection_secret AS mcp_introspection_secret_19, a0_.created_at AS created_at_20, a0_.updated_at AS updated_at_21, a1_.id AS id_22, a1_.enable_matomo AS enable_matomo_23, a1_.matomo_site_url AS matomo_site_url_24, a1_.matomo_site_id AS matomo_site_id_25, a1_.enable_google_analytics AS enable_google_analytics_26, a1_.google_analytics_id AS google_analytics_id_27, a1_.custom_head_scripts AS custom_head_scripts_28, a1_.custom_body_scripts AS custom_body_scripts_29, a1_.meta_title AS meta_title_30, a1_.meta_description AS meta_description_31, a1_.meta_keywords AS meta_keywords_32, a1_.created_at AS created_at_33, a1_.updated_at AS updated_at_34, a2_.id AS id_35, a2_.enable_cdn AS enable_cdn_36, a2_.cdn_endpoint AS cdn_endpoint_37, a2_.cdn_access_key AS cdn_access_key_38, a2_.cdn_secret_key AS cdn_secret_key_39, a2_.cdn_bucket AS cdn_bucket_40, a2_.cdn_region AS cdn_region_41, a2_.cdn_public_url AS cdn_public_url_42, a2_.backups_bucket AS backups_bucket_43, a2_.backup_retention_days AS backup_retention_days_44, a2_.created_at AS created_at_45, a2_.updated_at AS updated_at_46, a3_.id AS id_47, a3_.theme AS theme_48, a3_.primary_color AS primary_color_49, a3_.secondary_color AS secondary_color_50, a3_.debug_mode AS debug_mode_51, a3_.allow_registration AS allow_registration_52, a3_.require_email_verification AS require_email_verification_53, a3_.session_timeout AS session_timeout_54, a3_.maintenance_mode AS maintenance_mode_55, a3_.created_at AS created_at_56, a3_.updated_at AS updated_at_57, a0_.default_bug_assignee_id AS default_bug_assignee_id_58, a1_.app_settings_id AS app_settings_id_59, a2_.app_settings_id AS app_settings_id_60, a3_.app_settings_id AS app_settings_id_61 FROM app_settings a0_ LEFT JOIN app_settings_analytics a1_ ON a0_.id = a1_.app_settings_id LEFT JOIN app_settings_cdn a2_ ON a0_.id = a2_.app_settings_id LEFT JOIN app_settings_system a3_ ON a0_.id = a3_.app_settings_id LIMIT 1;
|
| 5 |
0.86 ms |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.api_key AS api_key_3, t0.maxmind_license_key AS maxmind_license_key_4, t0.mode AS mode_5, t0.geoblock_countries AS geoblock_countries_6, t0.whitelist_ips AS whitelist_ips_7, t0.tested_at AS tested_at_8, t0.tested_ok AS tested_ok_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.app_settings_id AS app_settings_id_12 FROM app_settings_security t0 WHERE t0.app_settings_id = ?
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.api_key AS api_key_3, t0.maxmind_license_key AS maxmind_license_key_4, t0.mode AS mode_5, t0.geoblock_countries AS geoblock_countries_6, t0.whitelist_ips AS whitelist_ips_7, t0.tested_at AS tested_at_8, t0.tested_ok AS tested_ok_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.app_settings_id AS app_settings_id_12 FROM app_settings_security t0 WHERE t0.app_settings_id = 1;
|
| 6 |
3.23 ms |
SELECT t0.id AS id_1, t0.app_name AS app_name_2, t0.public_url AS public_url_3, t0.support_email AS support_email_4, t0.app_description AS app_description_5, t0.favicon_path AS favicon_path_6, t0.logo_path AS logo_path_7, t0.login_background_image AS login_background_image_8, t0.footer_text AS footer_text_9, t0.maintenance_message AS maintenance_message_10, t0.company_name AS company_name_11, t0.company_address AS company_address_12, t0.company_phone AS company_phone_13, t0.company_website AS company_website_14, t0.company_email AS company_email_15, t0.currency AS currency_16, t0.timezone AS timezone_17, t0.bug_auto_assignment_enabled AS bug_auto_assignment_enabled_18, t0.bug_review_reassignment_enabled AS bug_review_reassignment_enabled_19, t0.mcp_introspection_secret AS mcp_introspection_secret_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t23.id AS id_24, t23.enable_matomo AS enable_matomo_25, t23.matomo_site_url AS matomo_site_url_26, t23.matomo_site_id AS matomo_site_id_27, t23.enable_google_analytics AS enable_google_analytics_28, t23.google_analytics_id AS google_analytics_id_29, t23.custom_head_scripts AS custom_head_scripts_30, t23.custom_body_scripts AS custom_body_scripts_31, t23.meta_title AS meta_title_32, t23.meta_description AS meta_description_33, t23.meta_keywords AS meta_keywords_34, t23.created_at AS created_at_35, t23.updated_at AS updated_at_36, t23.app_settings_id AS app_settings_id_37, t38.id AS id_39, t38.enable_cdn AS enable_cdn_40, t38.cdn_endpoint AS cdn_endpoint_41, t38.cdn_access_key AS cdn_access_key_42, t38.cdn_secret_key AS cdn_secret_key_43, t38.cdn_bucket AS cdn_bucket_44, t38.cdn_region AS cdn_region_45, t38.cdn_public_url AS cdn_public_url_46, t38.backups_bucket AS backups_bucket_47, t38.backup_retention_days AS backup_retention_days_48, t38.created_at AS created_at_49, t38.updated_at AS updated_at_50, t38.app_settings_id AS app_settings_id_51, t52.id AS id_53, t52.theme AS theme_54, t52.primary_color AS primary_color_55, t52.secondary_color AS secondary_color_56, t52.debug_mode AS debug_mode_57, t52.allow_registration AS allow_registration_58, t52.require_email_verification AS require_email_verification_59, t52.session_timeout AS session_timeout_60, t52.maintenance_mode AS maintenance_mode_61, t52.created_at AS created_at_62, t52.updated_at AS updated_at_63, t52.app_settings_id AS app_settings_id_64, t65.id AS id_66, t65.enabled AS enabled_67, t65.api_key AS api_key_68, t65.maxmind_license_key AS maxmind_license_key_69, t65.mode AS mode_70, t65.geoblock_countries AS geoblock_countries_71, t65.whitelist_ips AS whitelist_ips_72, t65.tested_at AS tested_at_73, t65.tested_ok AS tested_ok_74, t65.created_at AS created_at_75, t65.updated_at AS updated_at_76, t65.app_settings_id AS app_settings_id_77, t0.default_bug_assignee_id AS default_bug_assignee_id_78 FROM app_settings t0 LEFT JOIN app_settings_analytics t23 ON t23.app_settings_id = t0.id LEFT JOIN app_settings_cdn t38 ON t38.app_settings_id = t0.id LEFT JOIN app_settings_system t52 ON t52.app_settings_id = t0.id LEFT JOIN app_settings_security t65 ON t65.app_settings_id = t0.id LIMIT 1
SELECT
t0.id AS id_1,
t0.app_name AS app_name_2,
t0.public_url AS public_url_3,
t0.support_email AS support_email_4,
t0.app_description AS app_description_5,
t0.favicon_path AS favicon_path_6,
t0.logo_path AS logo_path_7,
t0.login_background_image AS login_background_image_8,
t0.footer_text AS footer_text_9,
t0.maintenance_message AS maintenance_message_10,
t0.company_name AS company_name_11,
t0.company_address AS company_address_12,
t0.company_phone AS company_phone_13,
t0.company_website AS company_website_14,
t0.company_email AS company_email_15,
t0.currency AS currency_16,
t0.timezone AS timezone_17,
t0.bug_auto_assignment_enabled AS bug_auto_assignment_enabled_18,
t0.bug_review_reassignment_enabled AS bug_review_reassignment_enabled_19,
t0.mcp_introspection_secret AS mcp_introspection_secret_20,
t0.created_at AS created_at_21,
t0.updated_at AS updated_at_22,
t23.id AS id_24,
t23.enable_matomo AS enable_matomo_25,
t23.matomo_site_url AS matomo_site_url_26,
t23.matomo_site_id AS matomo_site_id_27,
t23.enable_google_analytics AS enable_google_analytics_28,
t23.google_analytics_id AS google_analytics_id_29,
t23.custom_head_scripts AS custom_head_scripts_30,
t23.custom_body_scripts AS custom_body_scripts_31,
t23.meta_title AS meta_title_32,
t23.meta_description AS meta_description_33,
t23.meta_keywords AS meta_keywords_34,
t23.created_at AS created_at_35,
t23.updated_at AS updated_at_36,
t23.app_settings_id AS app_settings_id_37,
t38.id AS id_39,
t38.enable_cdn AS enable_cdn_40,
t38.cdn_endpoint AS cdn_endpoint_41,
t38.cdn_access_key AS cdn_access_key_42,
t38.cdn_secret_key AS cdn_secret_key_43,
t38.cdn_bucket AS cdn_bucket_44,
t38.cdn_region AS cdn_region_45,
t38.cdn_public_url AS cdn_public_url_46,
t38.backups_bucket AS backups_bucket_47,
t38.backup_retention_days AS backup_retention_days_48,
t38.created_at AS created_at_49,
t38.updated_at AS updated_at_50,
t38.app_settings_id AS app_settings_id_51,
t52.id AS id_53,
t52.theme AS theme_54,
t52.primary_color AS primary_color_55,
t52.secondary_color AS secondary_color_56,
t52.debug_mode AS debug_mode_57,
t52.allow_registration AS allow_registration_58,
t52.require_email_verification AS require_email_verification_59,
t52.session_timeout AS session_timeout_60,
t52.maintenance_mode AS maintenance_mode_61,
t52.created_at AS created_at_62,
t52.updated_at AS updated_at_63,
t52.app_settings_id AS app_settings_id_64,
t65.id AS id_66,
t65.enabled AS enabled_67,
t65.api_key AS api_key_68,
t65.maxmind_license_key AS maxmind_license_key_69,
t65.mode AS mode_70,
t65.geoblock_countries AS geoblock_countries_71,
t65.whitelist_ips AS whitelist_ips_72,
t65.tested_at AS tested_at_73,
t65.tested_ok AS tested_ok_74,
t65.created_at AS created_at_75,
t65.updated_at AS updated_at_76,
t65.app_settings_id AS app_settings_id_77,
t0.default_bug_assignee_id AS default_bug_assignee_id_78
FROM
app_settings t0
LEFT JOIN app_settings_analytics t23 ON t23.app_settings_id = t0.id
LEFT JOIN app_settings_cdn t38 ON t38.app_settings_id = t0.id
LEFT JOIN app_settings_system t52 ON t52.app_settings_id = t0.id
LEFT JOIN app_settings_security t65 ON t65.app_settings_id = t0.id
LIMIT
1
SELECT t0.id AS id_1, t0.app_name AS app_name_2, t0.public_url AS public_url_3, t0.support_email AS support_email_4, t0.app_description AS app_description_5, t0.favicon_path AS favicon_path_6, t0.logo_path AS logo_path_7, t0.login_background_image AS login_background_image_8, t0.footer_text AS footer_text_9, t0.maintenance_message AS maintenance_message_10, t0.company_name AS company_name_11, t0.company_address AS company_address_12, t0.company_phone AS company_phone_13, t0.company_website AS company_website_14, t0.company_email AS company_email_15, t0.currency AS currency_16, t0.timezone AS timezone_17, t0.bug_auto_assignment_enabled AS bug_auto_assignment_enabled_18, t0.bug_review_reassignment_enabled AS bug_review_reassignment_enabled_19, t0.mcp_introspection_secret AS mcp_introspection_secret_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t23.id AS id_24, t23.enable_matomo AS enable_matomo_25, t23.matomo_site_url AS matomo_site_url_26, t23.matomo_site_id AS matomo_site_id_27, t23.enable_google_analytics AS enable_google_analytics_28, t23.google_analytics_id AS google_analytics_id_29, t23.custom_head_scripts AS custom_head_scripts_30, t23.custom_body_scripts AS custom_body_scripts_31, t23.meta_title AS meta_title_32, t23.meta_description AS meta_description_33, t23.meta_keywords AS meta_keywords_34, t23.created_at AS created_at_35, t23.updated_at AS updated_at_36, t23.app_settings_id AS app_settings_id_37, t38.id AS id_39, t38.enable_cdn AS enable_cdn_40, t38.cdn_endpoint AS cdn_endpoint_41, t38.cdn_access_key AS cdn_access_key_42, t38.cdn_secret_key AS cdn_secret_key_43, t38.cdn_bucket AS cdn_bucket_44, t38.cdn_region AS cdn_region_45, t38.cdn_public_url AS cdn_public_url_46, t38.backups_bucket AS backups_bucket_47, t38.backup_retention_days AS backup_retention_days_48, t38.created_at AS created_at_49, t38.updated_at AS updated_at_50, t38.app_settings_id AS app_settings_id_51, t52.id AS id_53, t52.theme AS theme_54, t52.primary_color AS primary_color_55, t52.secondary_color AS secondary_color_56, t52.debug_mode AS debug_mode_57, t52.allow_registration AS allow_registration_58, t52.require_email_verification AS require_email_verification_59, t52.session_timeout AS session_timeout_60, t52.maintenance_mode AS maintenance_mode_61, t52.created_at AS created_at_62, t52.updated_at AS updated_at_63, t52.app_settings_id AS app_settings_id_64, t65.id AS id_66, t65.enabled AS enabled_67, t65.api_key AS api_key_68, t65.maxmind_license_key AS maxmind_license_key_69, t65.mode AS mode_70, t65.geoblock_countries AS geoblock_countries_71, t65.whitelist_ips AS whitelist_ips_72, t65.tested_at AS tested_at_73, t65.tested_ok AS tested_ok_74, t65.created_at AS created_at_75, t65.updated_at AS updated_at_76, t65.app_settings_id AS app_settings_id_77, t0.default_bug_assignee_id AS default_bug_assignee_id_78 FROM app_settings t0 LEFT JOIN app_settings_analytics t23 ON t23.app_settings_id = t0.id LEFT JOIN app_settings_cdn t38 ON t38.app_settings_id = t0.id LEFT JOIN app_settings_system t52 ON t52.app_settings_id = t0.id LEFT JOIN app_settings_security t65 ON t65.app_settings_id = t0.id LIMIT 1;
|
| 7 |
0.86 ms |
SELECT f0_.id AS id_0, f0_.ip_address AS ip_address_1, f0_.cidr AS cidr_2, f0_.reason AS reason_3, f0_.banned_by_user_id AS banned_by_user_id_4, f0_.banned_at AS banned_at_5, f0_.expires_at AS expires_at_6, f0_.source AS source_7, f0_.is_active AS is_active_8 FROM firewall_ban f0_ WHERE f0_.ip_address = ? AND f0_.is_active = ? AND (f0_.expires_at IS NULL OR f0_.expires_at > ?) LIMIT 1
Parameters: [
"172.68.210.241"
1
"2026-09-06 23:36:15"
]
SELECT f0_.id AS id_0, f0_.ip_address AS ip_address_1, f0_.cidr AS cidr_2, f0_.reason AS reason_3, f0_.banned_by_user_id AS banned_by_user_id_4, f0_.banned_at AS banned_at_5, f0_.expires_at AS expires_at_6, f0_.source AS source_7, f0_.is_active AS is_active_8 FROM firewall_ban f0_ WHERE f0_.ip_address = '172.68.210.241' AND f0_.is_active = 1 AND (f0_.expires_at IS NULL OR f0_.expires_at > '2026-09-06 23:36:15') LIMIT 1;
|
| 8 |
2.01 ms |
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.timezone AS timezone_10, t0.preferences AS preferences_11, t0.profile_image AS profile_image_12, t0.api_token AS api_token_13, t0.is_active AS is_active_14, t0.organization_role AS organization_role_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.organization_id AS organization_id_18 FROM "user" t0 WHERE t0.email = ? LIMIT 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.timezone AS timezone_10, t0.preferences AS preferences_11, t0.profile_image AS profile_image_12, t0.api_token AS api_token_13, t0.is_active AS is_active_14, t0.organization_role AS organization_role_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.organization_id AS organization_id_18 FROM "user" t0 WHERE t0.email = '[email protected]' LIMIT 1;
|
| 9 |
6.19 ms |
SELECT COUNT(u0_.id) AS sclr_0 FROM user_login_event u0_ WHERE u0_.user_id = ? AND u0_.ip_address = ? AND u0_.created_at >= ?
Parameters: [
1
"172.68.210.241"
"2026-06-08 23:36:15"
]
SELECT COUNT(u0_.id) AS sclr_0 FROM user_login_event u0_ WHERE u0_.user_id = 1 AND u0_.ip_address = '172.68.210.241' AND u0_.created_at >= '2026-06-08 23:36:15';
|
| 10 |
0.59 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 11 |
2.81 ms |
INSERT INTO user_login_event (user_id, ip_address, country_code, user_agent, is_new_ip, is_new_country, created_at) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
1
"172.68.210.241"
null
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36"
0
null
"2026-09-06 23:36:15"
]
INSERT INTO user_login_event (user_id, ip_address, country_code, user_agent, is_new_ip, is_new_country, created_at) VALUES (1, '172.68.210.241', NULL, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 0, NULL, '2026-09-06 23:36:15');
|
| 12 |
0.83 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = ? AND t0.provider = ? AND t0.enabled = ? LIMIT 1
Parameters: [
"search"
"typesense"
1
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = 'search' AND t0.provider = 'typesense' AND t0.enabled = 1 LIMIT 1;
|
| 13 |
1.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = ? AND t0.provider = ? AND t0.enabled = ? LIMIT 1
Parameters: [
"search"
"typesense"
1
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = 'search' AND t0.provider = 'typesense' AND t0.enabled = 1 LIMIT 1;
|
| 14 |
0.71 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = ? AND t0.provider = ? AND t0.enabled = ? LIMIT 1
Parameters: [
"search"
"typesense"
1
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.provider AS provider_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.host AS host_7, t0.port AS port_8, t0.username AS username_9, t0.password AS password_10, t0.database AS database_11, t0.api_url AS api_url_12, t0.api_key AS api_key_13, t0.api_secret AS api_secret_14, t0.config AS config_15, t0.metadata AS metadata_16, t0.last_tested AS last_tested_17, t0.test_passed AS test_passed_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.project_id AS project_id_21 FROM integration t0 WHERE t0.type = 'search' AND t0.provider = 'typesense' AND t0.enabled = 1 LIMIT 1;
|
| 15 |
0.54 ms |
"COMMIT"
|
| 16 |
1.21 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = false
SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = 1 AND n0_.is_read = false;
|