Symfony Profiler

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

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;

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user_login_event u0_
WHERE
  u0_.user_id = ?
  AND u0_.ip_address = ?
  AND u0_.created_at >= ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user_login_event u0_ WHERE u0_.user_id = 1 AND u0_.ip_address = '172.68.210.240' AND u0_.created_at >= '2026-06-08 23:36:15';

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;

INSERT INTO user_login_event (
  user_id, ip_address, country_code,
  user_agent, is_new_ip, is_new_country,
  created_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

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.240', 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');

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;

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
  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;

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;

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

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.240' AND f0_.is_active = 1 AND (f0_.expires_at IS NULL OR f0_.expires_at > '2026-09-06 23:36:15') LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";