Symfony Profiler

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
  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
  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 = 'openai' AND t0.enabled = 1 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.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
  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 = '108.162.249.129' AND f0_.is_active = 1 AND (f0_.expires_at IS NULL OR f0_.expires_at > '2026-07-09 01:37:29') 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.id = ?

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.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.status AS status_5,
  t0.phase AS phase_6,
  t0.evolvelab_project AS evolvelab_project_7,
  t0.evolvelab_enabled AS evolvelab_enabled_8,
  t0.git_repository_url AS git_repository_url_9,
  t0.git_branch AS git_branch_10,
  t0.local_workspace_path AS local_workspace_path_11,
  t0.start_date AS start_date_12,
  t0.target_date AS target_date_13,
  t0.completed_date AS completed_date_14,
  t0.color AS color_15,
  t0.current_version AS current_version_16,
  t0.deployed_versions AS deployed_versions_17,
  t0.priority AS priority_18,
  t0.points_budget AS points_budget_19,
  t0.budget_alert_threshold AS budget_alert_threshold_20,
  t0.audit_budget_usd AS audit_budget_usd_21,
  t0.audit_max_commits_per_batch AS audit_max_commits_per_batch_22,
  t0.search_vector AS search_vector_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.owner_id AS owner_id_26,
  t0.terminal_id AS terminal_id_27,
  t0.primary_wiki_space_id AS primary_wiki_space_id_28
FROM
  project t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.status AS status_5, t0.phase AS phase_6, t0.evolvelab_project AS evolvelab_project_7, t0.evolvelab_enabled AS evolvelab_enabled_8, t0.git_repository_url AS git_repository_url_9, t0.git_branch AS git_branch_10, t0.local_workspace_path AS local_workspace_path_11, t0.start_date AS start_date_12, t0.target_date AS target_date_13, t0.completed_date AS completed_date_14, t0.color AS color_15, t0.current_version AS current_version_16, t0.deployed_versions AS deployed_versions_17, t0.priority AS priority_18, t0.points_budget AS points_budget_19, t0.budget_alert_threshold AS budget_alert_threshold_20, t0.audit_budget_usd AS audit_budget_usd_21, t0.audit_max_commits_per_batch AS audit_max_commits_per_batch_22, t0.search_vector AS search_vector_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.owner_id AS owner_id_26, t0.terminal_id AS terminal_id_27, t0.primary_wiki_space_id AS primary_wiki_space_id_28 FROM project t0 ORDER BY t0.name ASC;

SELECT
  t0_.id AS id_0,
  t0_.bug_number AS bug_number_1,
  t0_.title AS title_2,
  t0_.description AS description_3,
  t0_.url AS url_4,
  t0_.error_output AS error_output_5,
  t0_.resolution AS resolution_6,
  t0_.ai_suggestion AS ai_suggestion_7,
  t0_.error_type AS error_type_8,
  t0_.error_file AS error_file_9,
  t0_.error_line AS error_line_10,
  t0_.stack_trace AS stack_trace_11,
  t0_.fingerprint AS fingerprint_12,
  t0_.hit_count AS hit_count_13,
  t0_.request_data AS request_data_14,
  t0_.request_headers AS request_headers_15,
  t0_.user_ip_address AS user_ip_address_16,
  t0_.user_agent AS user_agent_17,
  t0_.php_version AS php_version_18,
  t0_.symfony_version AS symfony_version_19,
  t0_.server_name AS server_name_20,
  t0_.environment AS environment_21,
  t0_.source_type AS source_type_22,
  t0_.source_entity_id AS source_entity_id_23,
  t0_.sql_query AS sql_query_24,
  t0_.session_data AS session_data_25,
  t0_.type AS type_26,
  t0_.status AS status_27,
  t0_.priority AS priority_28,
  t0_.estimated_hours AS estimated_hours_29,
  t0_.actual_hours AS actual_hours_30,
  t0_.start_date AS start_date_31,
  t0_.due_date AS due_date_32,
  t0_.completed_date AS completed_date_33,
  t0_.external_id AS external_id_34,
  t0_.source AS source_35,
  t0_.external_url AS external_url_36,
  t0_.story_points AS story_points_37,
  t0_.remaining_hours AS remaining_hours_38,
  t0_.components AS components_39,
  t0_.custom_fields AS custom_fields_40,
  t0_.order_position AS order_position_41,
  t0_.search_vector AS search_vector_42,
  t0_.deployment_status AS deployment_status_43,
  t0_.deployed_to_dev_at AS deployed_to_dev_at_44,
  t0_.deployed_to_prod_at AS deployed_to_prod_at_45,
  t0_.git_branch AS git_branch_46,
  t0_.git_commits AS git_commits_47,
  t0_.recurring AS recurring_48,
  t0_.recurring_pattern AS recurring_pattern_49,
  t0_.recurring_end_date AS recurring_end_date_50,
  t0_.recurring_count AS recurring_count_51,
  t0_.flag AS flag_52,
  t0_.created_at AS created_at_53,
  t0_.updated_at AS updated_at_54,
  p1_.id AS id_55,
  p1_.name AS name_56,
  p1_.slug AS slug_57,
  p1_.description AS description_58,
  p1_.status AS status_59,
  p1_.phase AS phase_60,
  p1_.evolvelab_project AS evolvelab_project_61,
  p1_.evolvelab_enabled AS evolvelab_enabled_62,
  p1_.git_repository_url AS git_repository_url_63,
  p1_.git_branch AS git_branch_64,
  p1_.local_workspace_path AS local_workspace_path_65,
  p1_.start_date AS start_date_66,
  p1_.target_date AS target_date_67,
  p1_.completed_date AS completed_date_68,
  p1_.color AS color_69,
  p1_.current_version AS current_version_70,
  p1_.deployed_versions AS deployed_versions_71,
  p1_.priority AS priority_72,
  p1_.points_budget AS points_budget_73,
  p1_.budget_alert_threshold AS budget_alert_threshold_74,
  p1_.audit_budget_usd AS audit_budget_usd_75,
  p1_.audit_max_commits_per_batch AS audit_max_commits_per_batch_76,
  p1_.search_vector AS search_vector_77,
  p1_.created_at AS created_at_78,
  p1_.updated_at AS updated_at_79,
  u2_.id AS id_80,
  u2_.email AS email_81,
  u2_.roles AS roles_82,
  u2_.password AS password_83,
  u2_.totp_secret AS totp_secret_84,
  u2_.totp_enabled AS totp_enabled_85,
  u2_.firstname AS firstname_86,
  u2_.lastname AS lastname_87,
  u2_.theme AS theme_88,
  u2_.timezone AS timezone_89,
  u2_.preferences AS preferences_90,
  u2_.profile_image AS profile_image_91,
  u2_.api_token AS api_token_92,
  u2_.is_active AS is_active_93,
  u2_.organization_role AS organization_role_94,
  u2_.created_at AS created_at_95,
  u2_.updated_at AS updated_at_96,
  t0_.project_id AS project_id_97,
  t0_.parent_task_id AS parent_task_id_98,
  t0_.module_id AS module_id_99,
  t0_.use_case_id AS use_case_id_100,
  t0_.custom_status_id AS custom_status_id_101,
  t0_.assignee_id AS assignee_id_102,
  t0_.reporter_id AS reporter_id_103,
  t0_.milestone_id AS milestone_id_104,
  t0_.sprint_id AS sprint_id_105,
  p1_.owner_id AS owner_id_106,
  p1_.terminal_id AS terminal_id_107,
  p1_.primary_wiki_space_id AS primary_wiki_space_id_108,
  u2_.organization_id AS organization_id_109
FROM
  task t0_
  LEFT JOIN project p1_ ON t0_.project_id = p1_.id
  LEFT JOIN "user" u2_ ON t0_.assignee_id = u2_.id
WHERE
  t0_.status IN (?, ?, ?, ?, ?)
  AND t0_.type IN (?, ?, ?)
ORDER BY
  t0_.updated_at DESC
LIMIT
  5