Resolve "Improve performance of Search API (Advanced): merge_requests scope" (!30546) · Merge requests · GitLab.org / GitLab

Terri Chu requested to merge 215709-improve-performance-of-search-api-advanced-merge_requests-scope into master Apr 27, 2020

What does this MR do?

Issue #215709 (closed)

This MR changes the ElasticSearch results eager load behavior for the merge_requests scope to using BatchLoader lazy load methods. This should help to reduce N+1 queries. Unfortunately all of the N+1 queries for merge_requests scope were not able to be fixed so a follow up Issue has been created to address the remaining ones. The lazy attribute methods are called during pagination of the objects inside SearchResults. The lazy attribute methods are also used in the Entity MergeRequestBasic. However, that entity is used in other areas of the application so a lazy option is set in the API Search Controller to let the Entity determine which attribute method to use.

Tests were updated and a new test was written to detect N+1 queries for the web /search request.

Task list

Add lazy methods for attributes with N+1 queries in MergeRequest model
Use BatchLoader to lazily preload attributes
Update Entity to use new lazy methods (when appropriate)
Add new test to check for N+1 queries for search api merge_request scope
Add new test for /search endpoint for N+1 query check

Before

GET /api/v4/search?scope=merge_requests&search=*

318 queries

Started GET "/api/v4/search?scope=merge_requests&search=*" for 127.0.0.1 at 2020-05-05 14:06:34 -0400 (0.2ms) SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))::float as lag ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache' ApplicationSetting Load (0.8ms) SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT 1 ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache' PersonalAccessToken Load (0.2ms) SELECT "personal_access_tokens".* FROM "personal_access_tokens" WHERE "personal_access_tokens"."token_digest" = 'IWbhMuIod/IOwVTYFg5F1lhjTSrQHpL+0q1r64PFmpw=' LIMIT 1 ↳ app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ↳ lib/gitlab/auth/auth_finders.rb:101:in `find_user_from_access_token' (0.4ms) SELECT "features"."key" FROM "features" ↳ lib/feature.rb:15:in `feature_names' License Load (0.3ms) SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 1 ↳ ee/app/models/license.rb:269:in `load_license' MergeRequest Search (8.0ms) {index: "gitlab-development", type: "doc", body: {query: {bool: {must: [{simple_query_string: {fields: ["title^2", "description"], query: "*", default_operator: :and}}], filter: [{term: {type: "merge_request"}}, {has_parent: {parent_type: "project", query: {bool: {should: [[{bool: {filter: [{term: {visibility_level: 0}}, {terms: {"merge_requests_access_level"=>[20, 10]}}]}}], [{bool: {filter: [{term: {visibility_level: 10}}, {terms: {"merge_requests_access_level"=>[20, 10]}}]}}], [{bool: {filter: [{term: {visibility_level: 20}}, {terms: {"merge_requests_access_level"=>[20, 10]}}]}}]]}}}}]}}, sort: [{updated_at: {order: :desc}}, :_score], highlight: {fields: {title: {}, description: {}}}}, size: 20, from: 0} (0.5ms) SELECT COUNT(*) FROM "merge_requests" WHERE "merge_requests"."id" IN (31, 10, 9, 8, 27, 26, 25, 24, 23, 22, 17, 16, 15, 33, 32, 30, 29, 28, 21, 20) ↳ ee/lib/gitlab/elastic/search_results.rb:172:in `eager_load' MergeRequest Load (0.4ms) SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" IN (31, 10, 9, 8, 27, 26, 25, 24, 23, 22, 17, 16, 15, 33, 32, 30, 29, 28, 21, 20) ↳ ee/lib/gitlab/elastic/search_results.rb:172:in `eager_load' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (2, 3, 5, 6, 7, 8, 1) ↳ ee/lib/gitlab/elastic/search_results.rb:172:in `eager_load' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" IN (5, 3, 1, 2, 6, 7, 8) ↳ ee/lib/gitlab/elastic/search_results.rb:172:in `eager_load' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" IN (25, 23, 22, 26, 27, 28) ↳ ee/lib/gitlab/elastic/search_results.rb:172:in `eager_load' ProjectFeature Load (0.3ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 1 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.3ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 2 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 3 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' Group Load (0.5ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."type" = 'Group' LIMIT 1 ↳ ee/app/policies/ee/project_policy.rb:295:in `block (2 levels) in ' Group Load (0.5ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."parent_id" IS NULL LIMIT 1 ↳ app/models/namespace.rb:280:in `block in root_ancestor' ProjectFeature Load (0.3ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 5 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.2ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 6 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.3ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 7 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.2ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 8 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' Project Load (0.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 1 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.3ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 33 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 33 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 33 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 33 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 33 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 33 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 33 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' MergeRequestDiff Load (0.3ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 33 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 22 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 33 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.2ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 9 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 9 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 9 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 9 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 9 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 16 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 9 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.6ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 9 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.4ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 9 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 22 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 22 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.3ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 9 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 9 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.2ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 10 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 10 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 10 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 10 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 10 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 20 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 10 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.6ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 10 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.3ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 10 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 22 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 22 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 10 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 10 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.3ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 15 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 15 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 15 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 15 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 15 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 21 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 15 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 15 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.4ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 15 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.5ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.3ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 15 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 15 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.2ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 16 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 16 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 16 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 16 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 16 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 13 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 16 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 16 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.2ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 11 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.4ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.4ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 16 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.3ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 16 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.3ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 17 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 17 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 17 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 17 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 17 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 13 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 17 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 17 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.2ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 11 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 17 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 17 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.4ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 20 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 20 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 20 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 20 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 20 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 21 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 20 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 20 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.2ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 11 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 20 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 20 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.2ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 21 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 21 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 21 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 21 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.8ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 21 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 21 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 21 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 21 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.2ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 11 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 21 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 21 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.4ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.3ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 22 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 22 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 22 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 22 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 22 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 22 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.5ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 22 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.3ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 21 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 25 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 25 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 22 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 25 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 22 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.2ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 23 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 23 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 23 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 23 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 23 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 23 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 23 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.3ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 21 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.5ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 25 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 25 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.3ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 23 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 23 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.3ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 24 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 24 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 24 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 24 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 24 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 24 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 24 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.2ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 24 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 25 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 25 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 24 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.3ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 24 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.4ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 25 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 25 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 25 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 25 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 25 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 6 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 25 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 25 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.2ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 27 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 26 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 26 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 25 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 26 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 25 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.3ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 26 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 26 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 26 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 26 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 26 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 10 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 26 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 26 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.2ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 28 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 26 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 26 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 26 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 26 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.3ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 27 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 27 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 27 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 27 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 27 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 15 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 27 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.6ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 27 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.3ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 27 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 26 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 26 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.3ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 27 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 27 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.3ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 28 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 28 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 28 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 28 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 28 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 15 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 28 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.6ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 28 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.4ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 30 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 26 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 26 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 28 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 28 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 7 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.2ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 29 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 29 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 29 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 29 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 29 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 8 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 29 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 29 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.2ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 33 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 7 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.5ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 27 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.4ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 27 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.3ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 29 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 27 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' Timelog Load (0.3ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 29 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 8 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.2ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 30 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 30 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 30 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 30 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 30 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 4 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 30 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 30 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.3ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 36 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 8 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 28 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 28 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 30 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 28 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' Timelog Load (0.4ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 30 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 8 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.4ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 31 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 31 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 31 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 31 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 31 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 31 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 31 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.2ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 37 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 8 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 28 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 28 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 61 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 31 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 1 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.2ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 32 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 32 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 32 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 32 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.7ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 32 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 32 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 32 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 32 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 32 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map' Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 ↳ app/models/merge_request.rb:1005:in `for_fork?' MergeRequest::Metrics Load (0.2ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 8 LIMIT 1 ↳ lib/api/entities/merge_request_basic.rb:7:in `block in ' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 8 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 8 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 8 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 8 ORDER BY "users"."id" ASC LIMIT 1 ↳ app/models/concerns/deprecated_assignee.rb:29:in `assignee' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 4 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' User Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "merge_request_assignees" ON "users"."id" = "merge_request_assignees"."user_id" WHERE "merge_request_assignees"."merge_request_id" = 8 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Label Load (0.4ms) SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 8 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC ↳ lib/api/entities/merge_request_basic.rb:42:in `map' Milestone Load (0.3ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 10 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' Project Load (0.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 22 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 22 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' MergeRequestDiff Load (0.2ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 8 LIMIT 1 ↳ app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association' Timelog Load (0.2ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" = 8 ↳ lib/api/entities/issuable_time_stats.rb:21:in `map'

gpt results

API


█ Results summary

* Environment:                Localhost
* Environment Version:        13.0.0-pre `d3bd29eaf08`
* Option:                     60s_20rps
* Date:                       2020-05-05
* Run Time:                   3m 7.7s (Start: 19:09:14 UTC, End: 19:12:22 UTC)
* GPT Version:                v1.2.6

NAME                   | RPS  | RPS RESULT        | TTFB AVG  | TTFB P90              | REQ STATUS      | RESULT
-----------------------|------|-------------------|-----------|-----------------------|-----------------|----------------
api_v4_search_global   | 20/s | 9.27/s (>4.80/s)  | 9358.61ms | 12552.56ms (<25000ms) | 99.81% (>9.5%)  | Passed
api_v4_search_groups   | 20/s | 14.62/s (>4.80/s) | 5822.01ms | 6851.91ms (<25000ms)  | 100.00% (>9.5%) | Passed
api_v4_search_projects | 20/s | 13.67/s (>4.80/s) | 5184.45ms | 6340.05ms (<25000ms)  | 100.00% (>9.5%) | Passed

█ Results files

k6/results/localhost_v13-0-0-pre_2020-05-05_150914/localhost_v13-0-0-pre_2020-05-05_150914_results_output.log
k6/results/localhost_v13-0-0-pre_2020-05-05_150914/localhost_v13-0-0-pre_2020-05-05_150914_results.json
k6/results/localhost_v13-0-0-pre_2020-05-05_150914/localhost_v13-0-0-pre_2020-05-05_150914_results.txt

After

GET /api/v4/search?scope=merge_requests&search=*

Include

151 queries

Started GET "/api/v4/search?scope=merge_requests&search=*" for 127.0.0.1 at 2020-05-18 13:37:18 -0400 (0.8ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC ↳ lib/gitlab/middleware/basic_health_check.rb:25:in `call' ApplicationSetting Load (2.4ms) SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT 1 ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache' (2.3ms) SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))::float as lag ↳ app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable' PersonalAccessToken Load (0.7ms) SELECT "personal_access_tokens".* FROM "personal_access_tokens" WHERE "personal_access_tokens"."token_digest" = 'R27ZoLo1xAaezTWG/7z4uMnF9M8yUPN1lDKLEh0cQq4=' LIMIT 1 ↳ app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable' User Load (2.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ↳ lib/gitlab/auth/auth_finders.rb:102:in `find_user_from_access_token' (0.6ms) SELECT "features"."key" FROM "features" ↳ lib/feature.rb:15:in `feature_names' License Load (0.4ms) SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 100 ↳ ee/app/models/license.rb:271:in `load_license' MergeRequest Search (43.6ms) {index: "gitlab-development", type: "doc", body: {query: {bool: {must: [{simple_query_string: {fields: ["title^2", "description"], query: "*", default_operator: :and}}], filter: [{term: {type: "merge_request"}}, {has_parent: {parent_type: "project", query: {bool: {should: [[{bool: {filter: [{term: {visibility_level: 0}}, {terms: {"merge_requests_access_level"=>[20, 10]}}]}}], [{bool: {filter: [{term: {visibility_level: 10}}, {terms: {"merge_requests_access_level"=>[20, 10]}}]}}], [{bool: {filter: [{term: {visibility_level: 20}}, {terms: {"merge_requests_access_level"=>[20, 10]}}]}}]]}}}}]}}, sort: [{updated_at: {order: :desc}}, :_score], highlight: {fields: {title: {}, description: {}}}}, size: 20, from: 0} (3.1ms) SELECT COUNT(*) FROM "merge_requests" WHERE "merge_requests"."id" IN (31, 3599, 3607, 3645, 3601, 3643, 3603, 3605, 10, 9, 8, 27, 26, 25, 24, 23, 22, 17, 16, 15) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' MergeRequest Load (0.9ms) SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" IN (31, 3599, 3607, 3645, 3601, 3643, 3603, 3605, 10, 9, 8, 27, 26, 25, 24, 23, 22, 17, 16, 15) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' MergeRequestAssignee Load (0.5ms) SELECT "merge_request_assignees".* FROM "merge_request_assignees" WHERE "merge_request_assignees"."merge_request_id" IN (8, 9, 10, 15, 16, 17, 22, 23, 24, 25, 26, 27, 31, 3599, 3601, 3603, 3605, 3607, 3643, 3645) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (5, 16, 4, 6, 21, 15, 17, 10, 18, 12) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (4, 16, 20, 21, 13, 1, 6, 10, 15, 2) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Note Load (7.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."type" IN ('DiffNote', 'DiscussionNote') AND "notes"."noteable_type" IN ('MergeRequest', 'DesignManagement::Design') AND "notes"."system" = FALSE AND "notes"."resolved_at" IS NULL AND "notes"."noteable_id" IN (8, 9, 10, 15, 16, 17, 22, 23, 24, 25, 26, 27, 31, 3599, 3601, 3603, 3605, 3607, 3643, 3645) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' LabelLink Load (2.1ms) SELECT "label_links".* FROM "label_links" WHERE "label_links"."target_type" = 'MergeRequest' AND "label_links"."target_id" IN (8, 9, 10, 15, 16, 17, 22, 23, 24, 25, 26, 27, 31, 3599, 3601, 3603, 3605, 3607, 3643, 3645) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Label Load (1.7ms) SELECT "labels".* FROM "labels" WHERE "labels"."id" IN (2, 74, 3, 9, 77, 76, 4, 78, 1, 75, 7, 83, 13, 79, 20, 80, 17, 19, 15, 11, 81, 12, 82, 31, 30, 90, 93, 91, 33, 38, 89, 92, 37, 42, 43, 95, 47, 94, 98, 39, 48, 41, 66, 107, 105, 106, 68, 65, 301, 306, 298, 297, 299, 305, 312, 317, 309, 308, 310, 316, 323, 328, 320, 319, 321, 327, 334, 339, 331, 330, 332, 338, 345, 350, 342, 341, 343, 349, 363, 368, 360, 359, 361, 367, 382, 387, 379, 378, 380, 386) ORDER BY "labels"."title" ASC ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Milestone Load (4.0ms) SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" IN (10, 9, 15, 11, 21, 24, 27, 28, 37, 177, 183, 189, 195, 201, 207, 213) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Timelog Load (0.6ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."merge_request_id" IN (8, 9, 10, 15, 16, 17, 22, 23, 24, 25, 26, 27, 31, 3599, 3601, 3603, 3605, 3607, 3643, 3645) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' MergeRequestDiff Load (1.6ms) SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" IN (8, 9, 10, 15, 16, 17, 22, 23, 24, 25, 26, 27, 61, 2750, 2752, 2754, 2756, 2758, 2794, 2796) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Project Load (2.9ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (2, 3, 5, 6, 8, 66, 69, 71, 73, 68, 80, 82) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Route Load (0.6ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" IN (5, 82, 80, 2, 66, 71, 3, 6, 8, 69, 68, 73) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Namespace Load (1.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" IN (25, 1, 22, 23, 26, 28) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Route Load (0.6ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" IN (1, 22, 23, 25, 26, 28) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (2, 3, 5, 6, 8, 66, 69, 71, 73, 68, 80, 82) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Route Load (0.4ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" IN (5, 82, 80, 2, 66, 71, 3, 6, 8, 69, 68, 73) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Namespace Load (0.5ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" IN (25, 1, 22, 23, 26, 28) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" IN (1, 22, 23, 25, 26, 28) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' MergeRequest::Metrics Load (0.8ms) SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" IN (8, 9, 10, 15, 16, 17, 22, 23, 24, 25, 26, 27, 31, 3599, 3601, 3603, 3605, 3607, 3643, 3645) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' MergeRequestBlock Load (0.5ms) SELECT "merge_request_blocks".* FROM "merge_request_blocks" WHERE "merge_request_blocks"."blocked_merge_request_id" IN (8, 9, 10, 15, 16, 17, 22, 23, 24, 25, 26, 27, 31, 3599, 3601, 3603, 3605, 3607, 3643, 3645) ↳ ee/lib/gitlab/elastic/search_results.rb:184:in `paginated_objects' ProjectFeature Load (0.9ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 82 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 2 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 3 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' Group Load (0.6ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."type" = 'Group' LIMIT 1 ↳ ee/app/policies/ee/project_policy.rb:313:in `block (2 levels) in ' Group Load (0.6ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 23 AND "namespaces"."parent_id" IS NULL LIMIT 1 ↳ app/models/namespace.rb:285:in `block in root_ancestor' Feature::FlipperGate Load (0.9ms) SELECT "feature_gates".* FROM "feature_gates" WHERE "feature_gates"."feature_key" = 'enforced_sso_requires_session' ↳ lib/feature.rb:67:in `enabled?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 5 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 6 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.8ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 8 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 66 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 69 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.5ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 71 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 73 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 68 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 80 LIMIT 1 ↳ app/policies/project_policy.rb:609:in `feature_available?' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 3645 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.8ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3645 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.9ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3645 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.8ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 82 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.5ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 9 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (3.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 9 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.5ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 9 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.8ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 22 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 22 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.7ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 10 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 10 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 10 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.6ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 22 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 22 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 15 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 15 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 15 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (1.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (1.2ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.4ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 16 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 16 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.5ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 16 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.8ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 23 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 23 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 17 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 17 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.5ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 17 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 22 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 22 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 22 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.7ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 25 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.4ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 25 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (2.0ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 23 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 23 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 23 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 24 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 24 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 24 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (1.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.6ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 25 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 25 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 25 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 25 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 25 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.8ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.6ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 26 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 26 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (1.1ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 26 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (1.1ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 26 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.6ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 26 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 6 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (1.1ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 26 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 26 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 27 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 27 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 27 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' (0.7ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 31 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 31 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.9ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 31 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 8 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.8ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 28 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 28 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 3599 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3599 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.6ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3599 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 66 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 3601 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3601 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3601 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 69 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.8ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.5ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 3603 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3603 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.7ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3603 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.8ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 71 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 3605 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3605 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3605 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 73 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.5ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 3607 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3607 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3607 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 68 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.7ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 3643 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3643 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 3643 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes' Project Load (0.9ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 80 LIMIT 1 ↳ app/helpers/milestones_routing_helper.rb:16:in `milestone_url' Namespace Load (0.4ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 LIMIT 1 ↳ config/application.rb:310:in `block (4 levels) in ' Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 8 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:396:in `user_notes_count' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 8 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:90:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 8 AND "award_emoji"."awardable_type" = 'MergeRequest' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:86:in `downvotes'

BatchLoader

124 queries

Started GET "/api/v4/search?scope=issues&search=*" for 127.0.0.1 at 2020-05-14 15:09:32 -0400 (0.6ms) SELECT EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))::float as lag ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache' ApplicationSetting Load (2.4ms) SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT 1 ↳ app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache' PersonalAccessToken Load (1.0ms) SELECT "personal_access_tokens".* FROM "personal_access_tokens" WHERE "personal_access_tokens"."token_digest" = 'R27ZoLo1xAaezTWG/7z4uMnF9M8yUPN1lDKLEh0cQq4=' LIMIT 1 ↳ app/models/concerns/token_authenticatable_strategies/digest.rb:8:in `find_token_authenticatable' User Load (2.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ↳ lib/gitlab/auth/auth_finders.rb:101:in `find_user_from_access_token' (0.4ms) SELECT "features"."key" FROM "features" ↳ lib/feature.rb:15:in `feature_names' License Load (0.4ms) SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 1 ↳ ee/app/models/license.rb:269:in `load_license' Issue Search (23.5ms) {index: "gitlab-development", type: "doc", body: {query: {bool: {must: [{simple_query_string: {fields: ["title^2", "description"], query: "*", default_operator: :and}}], filter: [{term: {type: "issue"}}, {has_parent: {parent_type: "project", query: {bool: {should: [[{bool: {filter: [{term: {visibility_level: 0}}, {terms: {"issues_access_level"=>[20, 10]}}]}}], [{bool: {filter: [{term: {visibility_level: 10}}, {terms: {"issues_access_level"=>[20, 10]}}]}}], [{bool: {filter: [{term: {visibility_level: 20}}, {terms: {"issues_access_level"=>[20, 10]}}]}}]]}}}}]}}, sort: [{updated_at: {order: :desc}}, :_score], highlight: {fields: {title: {}, description: {}}}}, size: 20, from: 0} (1.4ms) SELECT COUNT(*) FROM "issues" WHERE "issues"."id" IN (434, 7028, 7160, 7226, 7061, 7193, 7094, 7127, 433, 7027, 7159, 7225, 7060, 7192, 7093, 7126, 432, 7026, 7158, 7224) ↳ ee/lib/gitlab/elastic/search_results.rb:181:in `paginated_objects' Issue Load (0.8ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" IN (434, 7028, 7160, 7226, 7061, 7193, 7094, 7127, 433, 7027, 7159, 7225, 7060, 7192, 7093, 7126, 432, 7026, 7158, 7224) ↳ ee/lib/gitlab/elastic/search_results.rb:181:in `paginated_objects' Project Load (3.1ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (8, 66, 69, 71, 73, 68, 80, 82) ↳ ee/lib/gitlab/elastic/search_results.rb:181:in `paginated_objects' Route Load (0.6ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" IN (82, 80, 66, 71, 8, 69, 68, 73) ↳ ee/lib/gitlab/elastic/search_results.rb:181:in `paginated_objects' Namespace Load (1.7ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" IN (1, 28) ↳ ee/lib/gitlab/elastic/search_results.rb:181:in `paginated_objects' LabelLink Load (0.6ms) SELECT "label_links".* FROM "label_links" WHERE "label_links"."target_type" = 'Issue' AND "label_links"."target_id" IN (432, 433, 434, 7026, 7027, 7028, 7060, 7061, 7093, 7094, 7126, 7127, 7158, 7159, 7160, 7192, 7193, 7224, 7225, 7226) ↳ ee/lib/gitlab/elastic/search_results.rb:181:in `paginated_objects' Timelog Load (0.6ms) SELECT "timelogs".* FROM "timelogs" WHERE "timelogs"."issue_id" IN (432, 433, 434, 7026, 7027, 7028, 7060, 7061, 7093, 7094, 7126, 7127, 7158, 7159, 7160, 7192, 7193, 7224, 7225, 7226) ↳ ee/lib/gitlab/elastic/search_results.rb:181:in `paginated_objects' IssueAssignee Load (0.4ms) SELECT "issue_assignees".* FROM "issue_assignees" WHERE "issue_assignees"."issue_id" IN (432, 433, 434, 7026, 7027, 7028, 7060, 7061, 7093, 7094, 7126, 7127, 7158, 7159, 7160, 7192, 7193, 7224, 7225, 7226) ↳ ee/lib/gitlab/elastic/search_results.rb:181:in `paginated_objects' ProjectFeature Load (0.9ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 82 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 8 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 66 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.4ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 69 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.3ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 71 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.3ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 73 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.3ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 68 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' ProjectFeature Load (0.2ms) SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 80 LIMIT 1 ↳ app/policies/project_policy.rb:587:in `feature_available?' User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.9ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7226 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (1.9ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7226 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.5ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7226 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7226 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' Route Load (0.5ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 1 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 433 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 433 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 433 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 433 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 28 AND "routes"."source_type" = 'Namespace' LIMIT 1 ↳ app/models/concerns/routable.rb:77:in `full_path' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 434 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 434 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 434 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 434 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7026 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.5ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7026 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7026 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7026 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7027 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7027 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7027 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7027 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7028 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.5ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7028 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7028 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7028 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7060 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.5ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7060 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7060 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7060 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7061 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7061 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7061 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.5ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7061 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7093 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7093 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7093 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7093 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7094 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.5ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7094 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7094 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7094 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7126 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.5ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7126 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7126 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7126 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7127 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.5ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7127 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7127 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7127 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7158 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.5ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7158 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7158 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7158 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7159 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7159 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7159 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7159 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.2ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7160 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7160 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7160 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7160 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7192 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7192 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7192 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7192 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7193 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7193 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.6ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7193 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.6ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7193 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.3ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7224 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.5ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7224 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7224 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.4ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7224 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.4ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 7225 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.6ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 7225 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7225 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 7225 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes' User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1 ↳ ee/lib/gitlab/middleware/ip_restrictor.rb:14:in `block in call' (0.5ms) SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 432 AND "notes"."noteable_type" = 'Issue' AND "notes"."system" = FALSE ↳ app/models/concerns/issuable.rb:375:in `user_notes_count' (0.7ms) SELECT COUNT(*) FROM "merge_requests_closing_issues" INNER JOIN "merge_requests" ON "merge_requests"."id" = "merge_requests_closing_issues"."merge_request_id" INNER JOIN project_features ON merge_requests.target_project_id = project_features.project_id WHERE "merge_requests_closing_issues"."issue_id" = 432 AND (project_features.merge_requests_access_level >= 20) ↳ app/models/merge_requests_closing_issues.rb:32:in `count_for_issue' (0.3ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 432 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsup' ↳ app/models/concerns/awardable.rb:93:in `upvotes' (0.2ms) SELECT COUNT(*) FROM "award_emoji" WHERE "award_emoji"."awardable_id" = 432 AND "award_emoji"."awardable_type" = 'Issue' AND "award_emoji"."name" = 'thumbsdown' ↳ app/models/concerns/awardable.rb:89:in `downvotes'

gpt results

API

Include

█ Results summary

* Environment:                Localhost
* Environment Version:        13.0.0-pre `add62c9b0d5`
* Option:                     60s_20rps
* Date:                       2020-05-18
* Run Time:                   3m 4.74s (Start: 17:40:32 UTC, End: 17:43:36 UTC)
* GPT Version:                v1.3.0

NAME                   | RPS  | RPS RESULT        | TTFB AVG  | TTFB P90             | REQ STATUS      | RESULT
-----------------------|------|-------------------|-----------|----------------------|-----------------|----------------
api_v4_search_global   | 20/s | 13.13/s (>4.80/s) | 6570.05ms | 8393.67ms (<25000ms) | 100.00% (>9.5%) | Passed
api_v4_search_groups   | 20/s | 19.15/s (>4.80/s) | 1218.00ms | 3060.64ms (<25000ms) | 100.00% (>9.5%) | Passed
api_v4_search_projects | 20/s | 19.08/s (>4.80/s) | 418.61ms  | 910.96ms (<25000ms)  | 100.00% (>9.5%) | Passed

█ Results files

k6/results/localhost_v13-0-0-pre_2020-05-18_134032/localhost_v13-0-0-pre_2020-05-18_134032_results_output.log
k6/results/localhost_v13-0-0-pre_2020-05-18_134032/localhost_v13-0-0-pre_2020-05-18_134032_results.json
k6/results/localhost_v13-0-0-pre_2020-05-18_134032/localhost_v13-0-0-pre_2020-05-18_134032_results.txt

BatchLoader

█ Results summary

* Environment:                Localhost
* Environment Version:        13.0.0-pre `0efb4d83870`
* Option:                     60s_20rps
* Date:                       2020-05-13
* Run Time:                   3m 4.14s (Start: 20:02:35 UTC, End: 20:05:39 UTC)
* GPT Version:                v1.3.0

NAME                   | RPS  | RPS RESULT        | TTFB AVG  | TTFB P90             | REQ STATUS      | RESULT
-----------------------|------|-------------------|-----------|----------------------|-----------------|----------------
api_v4_search_global   | 20/s | 12.98/s (>4.80/s) | 6789.18ms | 8329.35ms (<25000ms) | 100.00% (>9.5%) | Passed
api_v4_search_groups   | 20/s | 19.37/s (>4.80/s) | 1229.39ms | 2983.73ms (<25000ms) | 100.00% (>9.5%) | Passed
api_v4_search_projects | 20/s | 19.13/s (>4.80/s) | 513.93ms  | 1071.75ms (<25000ms) | 100.00% (>9.5%) | Passed

█ Results files

k6/results/localhost_v13-0-0-pre_2020-05-13_160235/localhost_v13-0-0-pre_2020-05-13_160235_results_output.log
k6/results/localhost_v13-0-0-pre_2020-05-13_160235/localhost_v13-0-0-pre_2020-05-13_160235_results.json
k6/results/localhost_v13-0-0-pre_2020-05-13_160235/localhost_v13-0-0-pre_2020-05-13_160235_results.txt

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Review and add/update tests for this feature/bug. Consider all test levels. See the Test Planning Process.
Tested in all supported browsers
Informed Infrastructure department of a default or new setting change, if applicable per definition of done

Security

If this MR contains changes to processing or storing of credentials or tokens, authorization and authentication methods and other items described in the security review guidelines:

[-] Label as security and @ mention @gitlab-com/gl-security/appsec
[-] The MR includes necessary changes to maintain consistency between UI, API, email, or other methods
[-] Security reports checked/validated by a reviewer from the AppSec team

Edited May 31, 2022 by 🤖 GitLab Bot 🤖

Resolve "Improve performance of Search API (Advanced): merge_requests scope"

What does this MR do?

Before

gpt results

After

Include

BatchLoader

gpt results

Include

BatchLoader

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Security

Merge request reports