Make Issuable.labels_hash process in batches (!117572) · Merge requests · GitLab.org / GitLab

Stan Hu requested to merge sh-issuable-each-batch into master Apr 13, 2023

What does this MR do and why?

Describe in detail what your merge request does and why.

Screenshots or screen recordings

Before

With a project with 10000 issues, there is only one query:

[12] pry(main)> project.issues.labels_hash
   (60.9ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52)

After

With this change, we load the issues in batches:

[2] pry(main)> project.issues.labels_hash
  Issue Load (2.5ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) ORDER BY "issues"."id" ASC LIMIT 1 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:62:in `each_batch'*/
  Issue Load (1.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
Creating scope :order_name_asc. Overwriting existing method Label.order_name_asc.
Creating scope :order_name_desc. Overwriting existing method Label.order_name_desc.
   (2.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 503 AND "issues"."id" < 1503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 1503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 1503 AND "issues"."id" < 2503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 2503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 2503 AND "issues"."id" < 3503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 3503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 3503 AND "issues"."id" < 4503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 4503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 4503 AND "issues"."id" < 5503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 5503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 5503 AND "issues"."id" < 6503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 6503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 6503 AND "issues"."id" < 7503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 7503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 7503 AND "issues"."id" < 8503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 8503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 8503 AND "issues"."id" < 9503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 9503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.4ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 9503 AND "issues"."id" < 10503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 10503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 10503 AND "issues"."id" < 11503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 11503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 11503 AND "issues"."id" < 12503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.6ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 12503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.4ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 12503 AND "issues"."id" < 13503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 13503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 13503 AND "issues"."id" < 14503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 14503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 14503 AND "issues"."id" < 15503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 15503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 15503 AND "issues"."id" < 16503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 16503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 16503 AND "issues"."id" < 17503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 17503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 17503 AND "issues"."id" < 18503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 18503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 18503 AND "issues"."id" < 19503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 19503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 19503 AND "issues"."id" < 20503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 20503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 20503 AND "issues"."id" < 21503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.4ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 21503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 21503 AND "issues"."id" < 22503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.5ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 22503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 22503 AND "issues"."id" < 23503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 23503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 23503 AND "issues"."id" < 24503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.5ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 24503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 24503 AND "issues"."id" < 25503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 25503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 25503 AND "issues"."id" < 26503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 26503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 26503 AND "issues"."id" < 27503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (3.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 27503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 27503 AND "issues"."id" < 28503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (2.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 28503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 28503 AND "issues"."id" < 29503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (3.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 29503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 29503 AND "issues"."id" < 30503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (27.4ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 30503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 30503 AND "issues"."id" < 31503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.3ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 31503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.5ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 31503 AND "issues"."id" < 32503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 32503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 32503 AND "issues"."id" < 33503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (3.6ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 33503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 33503 AND "issues"."id" < 34503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 34503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 34503 AND "issues"."id" < 35503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (3.4ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 35503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 35503 AND "issues"."id" < 36503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (3.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 36503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 36503 AND "issues"."id" < 37503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 37503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 37503 AND "issues"."id" < 38503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 38503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 38503 AND "issues"."id" < 39503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (3.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 39503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 39503 AND "issues"."id" < 40503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (3.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 40503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 40503 AND "issues"."id" < 41503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (3.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 41503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 41503 AND "issues"."id" < 42503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (3.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 42503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 42503 AND "issues"."id" < 43503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 43503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 43503 AND "issues"."id" < 44503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 44503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 44503 AND "issues"."id" < 45503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.3ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 45503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 45503 AND "issues"."id" < 46503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.3ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 46503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 46503 AND "issues"."id" < 47503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.3ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 47503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 47503 AND "issues"."id" < 48503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.5ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 48503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 48503 AND "issues"."id" < 49503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 49503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 49503 AND "issues"."id" < 50503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 50503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 50503 AND "issues"."id" < 51503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 51503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 51503 AND "issues"."id" < 52503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 52503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 52503 AND "issues"."id" < 53503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (4.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 53503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.5ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 53503 AND "issues"."id" < 54503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (5.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 54503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 54503 AND "issues"."id" < 55503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (5.6ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 55503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 55503 AND "issues"."id" < 56503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (5.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 56503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 56503 AND "issues"."id" < 57503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 57503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.4ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 57503 AND "issues"."id" < 58503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 58503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 58503 AND "issues"."id" < 59503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (5.4ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 59503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 59503 AND "issues"."id" < 60503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (5.6ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 60503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 60503 AND "issues"."id" < 61503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.4ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 61503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.5ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 61503 AND "issues"."id" < 62503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 62503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 62503 AND "issues"."id" < 63503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (5.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 63503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 63503 AND "issues"."id" < 64503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.6ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 64503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 64503 AND "issues"."id" < 65503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 65503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 65503 AND "issues"."id" < 66503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.4ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 66503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 66503 AND "issues"."id" < 67503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 67503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 67503 AND "issues"."id" < 68503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 68503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 68503 AND "issues"."id" < 69503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 69503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 69503 AND "issues"."id" < 70503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.4ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 70503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 70503 AND "issues"."id" < 71503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.3ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 71503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 71503 AND "issues"."id" < 72503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 72503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 72503 AND "issues"."id" < 73503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.6ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 73503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 73503 AND "issues"."id" < 74503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 74503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.3ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 74503 AND "issues"."id" < 75503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 75503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.4ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 75503 AND "issues"."id" < 76503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.4ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 76503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 76503 AND "issues"."id" < 77503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (6.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 77503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 77503 AND "issues"."id" < 78503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 78503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.4ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 78503 AND "issues"."id" < 79503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (8.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 79503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 79503 AND "issues"."id" < 80503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.1ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 80503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 80503 AND "issues"."id" < 81503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 81503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 81503 AND "issues"."id" < 82503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 82503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 82503 AND "issues"."id" < 83503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (8.2ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 83503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 83503 AND "issues"."id" < 84503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.3ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 84503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 84503 AND "issues"."id" < 85503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 85503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 85503 AND "issues"."id" < 86503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.5ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 86503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 86503 AND "issues"."id" < 87503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (8.6ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 87503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.4ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 87503 AND "issues"."id" < 88503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (8.7ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 88503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 88503 AND "issues"."id" < 89503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (7.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 89503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 89503 AND "issues"."id" < 90503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 90503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 90503 AND "issues"."id" < 91503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 91503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 91503 AND "issues"."id" < 92503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 92503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 92503 AND "issues"."id" < 93503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 93503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 93503 AND "issues"."id" < 94503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (1.0ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 94503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 94503 AND "issues"."id" < 95503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 95503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.2ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 95503 AND "issues"."id" < 96503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 96503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 96503 AND "issues"."id" < 97503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.8ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 97503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 97503 AND "issues"."id" < 98503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 98503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 98503 AND "issues"."id" < 99503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.9ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 99503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (1.1ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 99503 AND "issues"."id" < 100503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/
  Issue Load (0.3ms)  SELECT "issues"."id" FROM "issues" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 100503 ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
   (0.4ms)  SELECT "issues"."id", "labels"."title" FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_type" = 'Issue' AND "label_links"."target_id" = "issues"."id" LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 52) AND "issues"."id" >= 100503 /*application:console,db_config_name:main,console_hostname:jet-arm.local,console_username:stanhu,line:/app/models/concerns/issuable.rb:161:in `block in labels_hash'*/

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

I have evaluated the MR acceptance checklist for this MR.

Edited Apr 13, 2023 by Stan Hu

Make Issuable.labels_hash process in batches