# Bug OP-7070 - n+1 query in work package list (for bcf_issues)

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-7070

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | High |
| Module |  |
| Target versions | 10.5.1 |
| Observed in versions |  |
| Sprint | 10.5.1 |
| Backlog bucket |  |
| Bug found in version (deprecated) |  |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

There is an n+1 query for bcf\_issues whenever the work package list is queried for:

``` bash
D, [2020-05-04T11:27:06.270672 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.274574 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.3ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 232], ["LIMIT", 1]]
D, [2020-05-04T11:27:06.275146 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.279088 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.3ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 233], ["LIMIT", 1]]
D, [2020-05-04T11:27:06.279749 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.283682 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.3ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 234], ["LIMIT", 1]]
D, [2020-05-04T11:27:06.284284 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.287861 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.2ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 246], ["LIMIT", 1]]
D, [2020-05-04T11:27:06.288440 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.292083 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.3ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 247], ["LIMIT", 1]]
D, [2020-05-04T11:27:06.292719 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.296189 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.2ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 248], ["LIMIT", 1]]
D, [2020-05-04T11:27:06.296771 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.302565 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.3ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 249], ["LIMIT", 1]]
D, [2020-05-04T11:27:06.303130 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.306804 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.2ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 250], ["LIMIT", 1]]
D, [2020-05-04T11:27:06.307454 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.311234 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.3ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 252], ["LIMIT", 1]]
D, [2020-05-04T11:27:06.311846 #14768] DEBUG -- :   ↳ lib/api/caching/cached_representer.rb:203:in `block in json_key_parts_of_represented'
D, [2020-05-04T11:27:06.316312 #14768] DEBUG -- :   Bim::Bcf::Issue Load (0.3ms)  SELECT "bcf_issues".* FROM "bcf_issues" WHERE "bcf_issues"."work_package_id" = $1 LIMIT $2  [["work_package_id", 254], ["LIMIT", 1]]
```

This will slow down the query considerably.
