mpeter50 · January 19, 2023 21:08
diff --git a/gitea log b/gitea log
 2023/01/19 22:00:04 [63c9af54] router: started   GET / for <IP>:0
 2023/01/19 22:00:04 models/user/user.go:1003:GetUserByIDCtx() [I] [63c9af54] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE `id`=? LIMIT 1 [4] - 17.626959ms
 2023/01/19 22:00:04 .../issues/stopwatch.go:140:HasUserStopwatch() [I] [63c9af54] [SQL] SELECT `id`, `issue_id`, `user_id`, `created_unix` FROM `stopwatch` WHERE (user_id = ?) LIMIT 1 [4] - 3.372742ms
 2023/01/19 22:00:04 ...nization/mini_org.go:67:GetUserOrgsList() [I] [63c9af54] [SQL] SELECT `user`.id,`user`.name,`user`.full_name,`user`.visibility,`user`.avatar,`user`.avatar_email,`user`.use_custom_avatar, count(distinct repo_id) as org_count FROM `user` INNER JOIN `team` ON `team`.org_id = `user`.id INNER JOIN `team_user` ON `team`.id = `team_user`.team_id LEFT JOIN (SELECT id as repo_id, owner_id as repo_owner_id FROM repository WHERE (`repository`.is_private=? AND `repository`.owner_id NOT IN (SELECT id FROM `user` WHERE type=? AND visibility IN (?))) OR `repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR `repository`.owner_id=? OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user WHERE `org_user`.uid=?))) `repository` ON `repository`.repo_owner_id = `team`.org_id WHERE (`team_user`.uid = ?) GROUP BY `user`.id,`user`.name,`user`.full_name,`user`.visibility,`user`.avatar,`user`.avatar_email,`user`.use_custom_avatar ORDER BY `user`.`name` ASC [false 1 private 4 0 4 4 false 4 4] - 49.066733ms
 2023/01/19 22:00:04 ...ers/web/user/home.go:79:Dashboard() [I] [63c9af54] [SQL] SELECT count(*) FROM `org_user` WHERE (uid=?) [4] - 1.324016ms
 2023/01/19 22:00:04 ...ties/user_heatmap.go:71:getUserHeatmapData() [I] [63c9af54] [SQL] SELECT created_unix DIV 900 * 900 AS timestamp, count(user_id) as contributions FROM `action` WHERE act_user_id IN (SELECT `user`.id FROM `user` WHERE (keep_activity_private=? AND visibility IN (?,?)) OR id=?) AND repo_id IN (SELECT id FROM repository WHERE (`repository`.is_private=? AND `repository`.owner_id NOT IN (SELECT id FROM `user` WHERE type=? AND visibility IN (?))) OR `repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR `repository`.owner_id=? OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user WHERE `org_user`.uid=?))) AND user_id=? AND act_user_id=? AND (created_unix > ?) GROUP BY timestamp ORDER BY timestamp [false public limited 4 false 1 private 4 0 4 4 false 4 4 4 1642626004] - 27.675928ms
 2023/01/19 22:00:07 [63c9af06] router: slow      GET / for <IP>:0, elapsed 3092.8ms @ web/home.go:33(web.Home)
 2023/01/19 22:02:39 ...activities/action.go:361:GetFeeds() [I] [63c9af54] [SQL] SELECT `action`.* FROM `action` INNER JOIN `repository` ON `repository`.id = `action`.repo_id WHERE act_user_id IN (SELECT `user`.id FROM `user` WHERE (keep_activity_private=? AND visibility IN (?,?)) OR id=?) AND repo_id IN (SELECT id FROM repository WHERE (`repository`.is_private=? AND `repository`.owner_id NOT IN (SELECT id FROM `user` WHERE type=? AND visibility IN (?))) OR `repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR `repository`.owner_id=? OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user WHERE `org_user`.uid=?))) AND user_id=? AND is_deleted=? ORDER BY `action`.`created_unix` DESC LIMIT 20 [false public limited 4 false 1 private 4 0 4 4 false 4 4 false] - 2m35.228546803s
 2023/01/19 22:02:39 ...ities/action_list.go:37:loadUsers() [I] [63c9af54] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE `id` IN (?) [5] - 4.902865ms
 2023/01/19 22:02:39 ...ities/action_list.go:63:loadRepositories() [I] [63c9af54] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix` FROM `repository` WHERE `id` IN (?,?,?,?) [241 867 293 803] - 1.776342ms
 2023/01/19 22:02:39 ...s/context/context.go:220:HTML() [D] [63c9af54] Template: user/dashboard/dashboard
 2023/01/19 22:02:39 ...user/notification.go:46:func1() [I] [63c9af54] [SQL] SELECT count(*) FROM `notification` WHERE (user_id = ?) AND (status = ?) [4 1] - 1.108ms
 2023/01/19 22:02:39 ...bce556200f/engine.go:1244:Get() [I] [63c9af54] [SQL] SELECT `id`, `uid`, `email`, `lower_email`, `is_activated`, `is_primary` FROM `email_address` WHERE `lower_email`=? LIMIT 1 [[email protected]] - 13.740984ms
 2023/01/19 22:02:39 ...ls/system/setting.go:122:GetSettings() [I] [63c9af54] [SQL] SELECT `id`, `setting_key`, `setting_value`, `version`, `created`, `updated` FROM `system_setting` WHERE setting_key IN (?) [picture.enable_federated_avatar] - 1.602938ms
 2023/01/19 22:02:39 ...bce556200f/engine.go:1244:Get() [I] [63c9af54] [SQL] SELECT `id`, `uid`, `email`, `lower_email`, `is_activated`, `is_primary` FROM `email_address` WHERE `lower_email`=? LIMIT 1 [[email protected]] - 1.402274ms
 2023/01/19 22:02:39 ...bce556200f/engine.go:1244:Get() [I] [63c9af54] [SQL] SELECT `id`, `uid`, `email`, `lower_email`, `is_activated`, `is_primary` FROM `email_address` WHERE `lower_email`=? LIMIT 1 [[email protected]] - 1.337164ms
 2023/01/19 22:02:39 [63c9af54] router: completed GET / for <IP>:0, 200 OK in 155428.7ms @ web/home.go:33(web.Home)
 2023/01/19 22:02:42 [63c9aff2] router: started   GET /repo/search?count_only=1&uid=4&team_id=0&q=&page=1&mode= for <IP>:0
 2023/01/19 22:02:42 models/user/user.go:1003:GetUserByIDCtx() [I] [63c9aff2] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE `id`=? LIMIT 1 [4] - 7.151608ms
 2023/01/19 22:02:42 .../issues/stopwatch.go:140:HasUserStopwatch() [I] [63c9aff2] [SQL] SELECT `id`, `issue_id`, `user_id`, `created_unix` FROM `stopwatch` WHERE (user_id = ?) LIMIT 1 [4] - 2.549588ms
 2023/01/19 22:02:42 ...ls/repo/repo_list.go:534:SearchRepositoryByCondition() [I] [63c9aff2] [SQL] SELECT count(*) FROM `repository` WHERE (owner_id=? OR (owner_id<>? AND (`repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user INNER JOIN `user` ON `user`.id = `org_user`.org_id WHERE `org_user`.uid=? AND `user`.`type`=? AND `user`.visibility=?))))) [4 4 4 0 4 false 4 1 private] - 67.746008ms
 2023/01/19 22:02:42 ...ls/repo/repo_list.go:544:SearchRepositoryByCondition() [I] [63c9aff2] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix` FROM `repository` WHERE (owner_id=? OR (owner_id<>? AND (`repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user INNER JOIN `user` ON `user`.id = `org_user`.org_id WHERE `org_user`.uid=? AND `user`.`type`=? AND `user`.visibility=?))))) ORDER BY name ASC LIMIT 30 [4 4 4 0 4 false 4 1 private] - 39.464572ms
 2023/01/19 22:02:42 ...ls/repo/repo_list.go:84:loadAttributes() [I] [63c9aff2] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE (id > 0) AND `id` IN (?,?) [4 5] - 2.85838ms
 2023/01/19 22:02:43 ...ls/repo/repo_list.go:96:loadAttributes() [I] [63c9aff2] [SQL] SELECT `id`, `repo_id`, `commit_id`, `is_primary`, `language`, `size`, `created_unix` FROM `language_stat` WHERE (`is_primary` = ? AND `language` != ?) AND `repo_id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [true other 100 590 464 588 856 605 761 465 716 522 102 231 466 827 545 551 548 560 553 644 650 561 17 262 192 189 94 320 782 406] - 303.970391ms
 2023/01/19 22:02:43 [63c9aff2] router: completed GET /repo/search?count_only=1&uid=4&team_id=0&q=&page=1&mode= for <IP>:0, 0  in 442.6ms @ repo/repo.go:473(repo.SearchRepo)
 2023/01/19 22:02:44 [63c9aff4] router: started   GET /repo/search?sort=updated&order=desc&uid=4&team_id=0&q=&page=1&limit=15&mode=&archived=false for <IP>:0
 2023/01/19 22:02:44 models/user/user.go:1003:GetUserByIDCtx() [I] [63c9aff4] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE `id`=? LIMIT 1 [4] - 1.698936ms
 2023/01/19 22:02:44 .../issues/stopwatch.go:140:HasUserStopwatch() [I] [63c9aff4] [SQL] SELECT `id`, `issue_id`, `user_id`, `created_unix` FROM `stopwatch` WHERE (user_id = ?) LIMIT 1 [4] - 2.079948ms
 2023/01/19 22:02:44 ...ls/repo/repo_list.go:534:SearchRepositoryByCondition() [I] [63c9aff4] [SQL] SELECT count(*) FROM `repository` WHERE (owner_id=? OR (owner_id<>? AND (`repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user INNER JOIN `user` ON `user`.id = `org_user`.org_id WHERE `org_user`.uid=? AND `user`.`type`=? AND `user`.visibility=?))))) AND is_archived=? [4 4 4 0 4 false 4 1 private false] - 23.807304ms
 2023/01/19 22:02:44 ...ls/repo/repo_list.go:544:SearchRepositoryByCondition() [I] [63c9aff4] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix` FROM `repository` WHERE (owner_id=? OR (owner_id<>? AND (`repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user INNER JOIN `user` ON `user`.id = `org_user`.org_id WHERE `org_user`.uid=? AND `user`.`type`=? AND `user`.visibility=?))))) AND is_archived=? ORDER BY updated_unix DESC LIMIT 15 [4 4 4 0 4 false 4 1 private false] - 31.600142ms
 2023/01/19 22:02:44 ...ls/repo/repo_list.go:84:loadAttributes() [I] [63c9aff4] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE (id > 0) AND `id` IN (?) [5] - 2.823973ms
 2023/01/19 22:02:44 ...ls/repo/repo_list.go:96:loadAttributes() [I] [63c9aff4] [SQL] SELECT `id`, `repo_id`, `commit_id`, `is_primary`, `language`, `size`, `created_unix` FROM `language_stat` WHERE (`is_primary` = ? AND `language` != ?) AND `repo_id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [true other 241 491 612 225 410 704 489 407 627 331 815 792 803 293 816] - 36.177606ms
 2023/01/19 22:02:44 [63c9aff4] router: completed GET /repo/search?sort=updated&order=desc&uid=4&team_id=0&q=&page=1&limit=15&mode=&archived=false for <IP>:0, 200 OK in 121.2ms @ repo/repo.go:473(repo.SearchRepo)
	2023/01/19 22:00:04 [63c9af54] router: started GET / for <IP>:0
	2023/01/19 22:00:04 models/user/user.go:1003:GetUserByIDCtx() [I] [63c9af54] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE `id`=? LIMIT 1 [4] - 17.626959ms
	2023/01/19 22:00:04 .../issues/stopwatch.go:140:HasUserStopwatch() [I] [63c9af54] [SQL] SELECT `id`, `issue_id`, `user_id`, `created_unix` FROM `stopwatch` WHERE (user_id = ?) LIMIT 1 [4] - 3.372742ms
	2023/01/19 22:00:04 ...nization/mini_org.go:67:GetUserOrgsList() [I] [63c9af54] [SQL] SELECT `user`.id,`user`.name,`user`.full_name,`user`.visibility,`user`.avatar,`user`.avatar_email,`user`.use_custom_avatar, count(distinct repo_id) as org_count FROM `user` INNER JOIN `team` ON `team`.org_id = `user`.id INNER JOIN `team_user` ON `team`.id = `team_user`.team_id LEFT JOIN (SELECT id as repo_id, owner_id as repo_owner_id FROM repository WHERE (`repository`.is_private=? AND `repository`.owner_id NOT IN (SELECT id FROM `user` WHERE type=? AND visibility IN (?))) OR `repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR `repository`.owner_id=? OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user WHERE `org_user`.uid=?))) `repository` ON `repository`.repo_owner_id = `team`.org_id WHERE (`team_user`.uid = ?) GROUP BY `user`.id,`user`.name,`user`.full_name,`user`.visibility,`user`.avatar,`user`.avatar_email,`user`.use_custom_avatar ORDER BY `user`.`name` ASC [false 1 private 4 0 4 4 false 4 4] - 49.066733ms
	2023/01/19 22:00:04 ...ers/web/user/home.go:79:Dashboard() [I] [63c9af54] [SQL] SELECT count(*) FROM `org_user` WHERE (uid=?) [4] - 1.324016ms
	2023/01/19 22:00:04 ...ties/user_heatmap.go:71:getUserHeatmapData() [I] [63c9af54] [SQL] SELECT created_unix DIV 900 * 900 AS timestamp, count(user_id) as contributions FROM `action` WHERE act_user_id IN (SELECT `user`.id FROM `user` WHERE (keep_activity_private=? AND visibility IN (?,?)) OR id=?) AND repo_id IN (SELECT id FROM repository WHERE (`repository`.is_private=? AND `repository`.owner_id NOT IN (SELECT id FROM `user` WHERE type=? AND visibility IN (?))) OR `repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR `repository`.owner_id=? OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user WHERE `org_user`.uid=?))) AND user_id=? AND act_user_id=? AND (created_unix > ?) GROUP BY timestamp ORDER BY timestamp [false public limited 4 false 1 private 4 0 4 4 false 4 4 4 1642626004] - 27.675928ms
	2023/01/19 22:00:07 [63c9af06] router: slow GET / for <IP>:0, elapsed 3092.8ms @ web/home.go:33(web.Home)
	2023/01/19 22:02:39 ...activities/action.go:361:GetFeeds() [I] [63c9af54] [SQL] SELECT `action`.* FROM `action` INNER JOIN `repository` ON `repository`.id = `action`.repo_id WHERE act_user_id IN (SELECT `user`.id FROM `user` WHERE (keep_activity_private=? AND visibility IN (?,?)) OR id=?) AND repo_id IN (SELECT id FROM repository WHERE (`repository`.is_private=? AND `repository`.owner_id NOT IN (SELECT id FROM `user` WHERE type=? AND visibility IN (?))) OR `repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR `repository`.owner_id=? OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user WHERE `org_user`.uid=?))) AND user_id=? AND is_deleted=? ORDER BY `action`.`created_unix` DESC LIMIT 20 [false public limited 4 false 1 private 4 0 4 4 false 4 4 false] - 2m35.228546803s
	2023/01/19 22:02:39 ...ities/action_list.go:37:loadUsers() [I] [63c9af54] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE `id` IN (?) [5] - 4.902865ms
	2023/01/19 22:02:39 ...ities/action_list.go:63:loadRepositories() [I] [63c9af54] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix` FROM `repository` WHERE `id` IN (?,?,?,?) [241 867 293 803] - 1.776342ms
	2023/01/19 22:02:39 ...s/context/context.go:220:HTML() [D] [63c9af54] Template: user/dashboard/dashboard
	2023/01/19 22:02:39 ...user/notification.go:46:func1() [I] [63c9af54] [SQL] SELECT count(*) FROM `notification` WHERE (user_id = ?) AND (status = ?) [4 1] - 1.108ms
	2023/01/19 22:02:39 ...bce556200f/engine.go:1244:Get() [I] [63c9af54] [SQL] SELECT `id`, `uid`, `email`, `lower_email`, `is_activated`, `is_primary` FROM `email_address` WHERE `lower_email`=? LIMIT 1 [[email protected]] - 13.740984ms
	2023/01/19 22:02:39 ...ls/system/setting.go:122:GetSettings() [I] [63c9af54] [SQL] SELECT `id`, `setting_key`, `setting_value`, `version`, `created`, `updated` FROM `system_setting` WHERE setting_key IN (?) [picture.enable_federated_avatar] - 1.602938ms
	2023/01/19 22:02:39 ...bce556200f/engine.go:1244:Get() [I] [63c9af54] [SQL] SELECT `id`, `uid`, `email`, `lower_email`, `is_activated`, `is_primary` FROM `email_address` WHERE `lower_email`=? LIMIT 1 [[email protected]] - 1.402274ms
	2023/01/19 22:02:39 ...bce556200f/engine.go:1244:Get() [I] [63c9af54] [SQL] SELECT `id`, `uid`, `email`, `lower_email`, `is_activated`, `is_primary` FROM `email_address` WHERE `lower_email`=? LIMIT 1 [[email protected]] - 1.337164ms
	2023/01/19 22:02:39 [63c9af54] router: completed GET / for <IP>:0, 200 OK in 155428.7ms @ web/home.go:33(web.Home)
	2023/01/19 22:02:42 [63c9aff2] router: started GET /repo/search?count_only=1&uid=4&team_id=0&q=&page=1&mode= for <IP>:0
	2023/01/19 22:02:42 models/user/user.go:1003:GetUserByIDCtx() [I] [63c9aff2] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE `id`=? LIMIT 1 [4] - 7.151608ms
	2023/01/19 22:02:42 .../issues/stopwatch.go:140:HasUserStopwatch() [I] [63c9aff2] [SQL] SELECT `id`, `issue_id`, `user_id`, `created_unix` FROM `stopwatch` WHERE (user_id = ?) LIMIT 1 [4] - 2.549588ms
	2023/01/19 22:02:42 ...ls/repo/repo_list.go:534:SearchRepositoryByCondition() [I] [63c9aff2] [SQL] SELECT count(*) FROM `repository` WHERE (owner_id=? OR (owner_id<>? AND (`repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user INNER JOIN `user` ON `user`.id = `org_user`.org_id WHERE `org_user`.uid=? AND `user`.`type`=? AND `user`.visibility=?))))) [4 4 4 0 4 false 4 1 private] - 67.746008ms
	2023/01/19 22:02:42 ...ls/repo/repo_list.go:544:SearchRepositoryByCondition() [I] [63c9aff2] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix` FROM `repository` WHERE (owner_id=? OR (owner_id<>? AND (`repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user INNER JOIN `user` ON `user`.id = `org_user`.org_id WHERE `org_user`.uid=? AND `user`.`type`=? AND `user`.visibility=?))))) ORDER BY name ASC LIMIT 30 [4 4 4 0 4 false 4 1 private] - 39.464572ms
	2023/01/19 22:02:42 ...ls/repo/repo_list.go:84:loadAttributes() [I] [63c9aff2] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE (id > 0) AND `id` IN (?,?) [4 5] - 2.85838ms
	2023/01/19 22:02:43 ...ls/repo/repo_list.go:96:loadAttributes() [I] [63c9aff2] [SQL] SELECT `id`, `repo_id`, `commit_id`, `is_primary`, `language`, `size`, `created_unix` FROM `language_stat` WHERE (`is_primary` = ? AND `language` != ?) AND `repo_id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [true other 100 590 464 588 856 605 761 465 716 522 102 231 466 827 545 551 548 560 553 644 650 561 17 262 192 189 94 320 782 406] - 303.970391ms
	2023/01/19 22:02:43 [63c9aff2] router: completed GET /repo/search?count_only=1&uid=4&team_id=0&q=&page=1&mode= for <IP>:0, 0 in 442.6ms @ repo/repo.go:473(repo.SearchRepo)
	2023/01/19 22:02:44 [63c9aff4] router: started GET /repo/search?sort=updated&order=desc&uid=4&team_id=0&q=&page=1&limit=15&mode=&archived=false for <IP>:0
	2023/01/19 22:02:44 models/user/user.go:1003:GetUserByIDCtx() [I] [63c9aff4] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE `id`=? LIMIT 1 [4] - 1.698936ms
	2023/01/19 22:02:44 .../issues/stopwatch.go:140:HasUserStopwatch() [I] [63c9aff4] [SQL] SELECT `id`, `issue_id`, `user_id`, `created_unix` FROM `stopwatch` WHERE (user_id = ?) LIMIT 1 [4] - 2.079948ms
	2023/01/19 22:02:44 ...ls/repo/repo_list.go:534:SearchRepositoryByCondition() [I] [63c9aff4] [SQL] SELECT count(*) FROM `repository` WHERE (owner_id=? OR (owner_id<>? AND (`repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user INNER JOIN `user` ON `user`.id = `org_user`.org_id WHERE `org_user`.uid=? AND `user`.`type`=? AND `user`.visibility=?))))) AND is_archived=? [4 4 4 0 4 false 4 1 private false] - 23.807304ms
	2023/01/19 22:02:44 ...ls/repo/repo_list.go:544:SearchRepositoryByCondition() [I] [63c9aff4] [SQL] SELECT `id`, `owner_id`, `owner_name`, `lower_name`, `name`, `description`, `website`, `original_service_type`, `original_url`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `num_projects`, `num_closed_projects`, `is_private`, `is_empty`, `is_archived`, `is_mirror`, `status`, `is_fork`, `fork_id`, `is_template`, `template_id`, `size`, `is_fsck_enabled`, `close_issues_via_commit_in_any_branch`, `topics`, `trust_model`, `avatar`, `created_unix`, `updated_unix` FROM `repository` WHERE (owner_id=? OR (owner_id<>? AND (`repository`.id IN (SELECT repo_id FROM `access` WHERE `access`.user_id=? AND `access`.mode>?) OR `repository`.id IN (SELECT `team_repo`.repo_id FROM team_repo INNER JOIN team_user ON `team_user`.team_id = `team_repo`.team_id WHERE `team_user`.uid=?) OR (`repository`.is_private=? AND `repository`.owner_id IN (SELECT `org_user`.org_id FROM org_user INNER JOIN `user` ON `user`.id = `org_user`.org_id WHERE `org_user`.uid=? AND `user`.`type`=? AND `user`.visibility=?))))) AND is_archived=? ORDER BY updated_unix DESC LIMIT 15 [4 4 4 0 4 false 4 1 private false] - 31.600142ms
	2023/01/19 22:02:44 ...ls/repo/repo_list.go:84:loadAttributes() [I] [63c9aff4] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `email_notifications_preference`, `passwd`, `passwd_hash_algo`, `must_change_password`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `language`, `description`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `is_restricted`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `num_teams`, `num_members`, `visibility`, `repo_admin_change_team_access`, `diff_view_style`, `theme`, `keep_activity_private` FROM `user` WHERE (id > 0) AND `id` IN (?) [5] - 2.823973ms
	2023/01/19 22:02:44 ...ls/repo/repo_list.go:96:loadAttributes() [I] [63c9aff4] [SQL] SELECT `id`, `repo_id`, `commit_id`, `is_primary`, `language`, `size`, `created_unix` FROM `language_stat` WHERE (`is_primary` = ? AND `language` != ?) AND `repo_id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [true other 241 491 612 225 410 704 489 407 627 331 815 792 803 293 816] - 36.177606ms
	2023/01/19 22:02:44 [63c9aff4] router: completed GET /repo/search?sort=updated&order=desc&uid=4&team_id=0&q=&page=1&limit=15&mode=&archived=false for <IP>:0, 200 OK in 121.2ms @ repo/repo.go:473(repo.SearchRepo)