# Api::V1::PublicationsController#publish

- **Period:** 13 May 09:29 UTC – 13 May 21:29 UTC
- **Throughput**: 0.0 / min
- **Average:** 31.0 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/api/v1/publications_controller.rb:133 | 17.0 | 1.0 | 54.84% | `Api::V1::PublicationsController#publish` |
| sql | app/models/publication.rb:98 | 1.25 | 4.0 | 16.13% | `BEGIN SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `cra…` |
| sql | app/controllers/api/v1/publications_controller.rb:162 | 1.5 | 2.0 | 9.68% | `SELECT `publications`.* FROM `publications` WHERE `publications`.`id` = ? LIMIT…` |
| code | /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525 | 2.0 | 1.0 | 6.45% | `Rails::Engine#call` |
| sql | app/controllers/api/v1/api_controller.rb:64 | 1.0 | 1.0 | 3.23% | `SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?` |
| sql | app/models/publication.rb:92 | 1.0 | 1.0 | 3.23% | `SELECT COUNT(*) FROM `publications` WHERE `publications`.`generated` = FALSE AN…` |
| sql | app/controllers/api/v1/api_controller.rb:26 | 1.0 | 1.0 | 3.23% | `SELECT `ip_black_lists`.* FROM `ip_black_lists` WHERE (block_expired_at <= NOW(…` |
| redis | app/models/publication.rb:123 | 1.0 | 1.0 | 3.23% | `multi` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135627/requests/Api::V1::PublicationsController%23publish?range=12h)