# Quiz::RanksController#show

- **Period:** 12 Jun 11:43 UTC – 12 Jun 16:40 UTC
- **Throughput**: 0.03 / min
- **Average:** 210.3 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | lib/quiz/stats.rb:120 | 66.3 | 1.0 | 31.53% | `WITH first_answers AS ( SELECT qa.user_id, qa.question_id, qa.proposition_id, R…` |
| sql | app/views/layouts/quiz_answer.html.erb:87 | 37.2 | 1.0 | 17.69% | `SELECT sub_categories.*, count(quiz_answers.id) as quiz_answers_count FROM "sub…` |
| sql | app/views/layouts/quiz_answer.html.erb:104 | 7.13 | 3.0 | 10.18% | `SELECT topics.*, count(quiz_answers.id) as quiz_answers_count FROM "topics" INN…` |
| sql | app/helpers/forms_helper.rb:80 | 16.0 | 1.0 | 7.61% | `SELECT DISTINCT "groups"."id", "groups"."name", "categories"."name", "categorie…` |
| sql | app/views/layouts/quiz_answer.html.erb:70 | 14.7 | 1.0 | 6.99% | `SELECT categories.*, count(quiz_answers.id) as quiz_answers_count FROM "categor…` |
| sql | lib/quiz/stats.rb:26 | 10.9 | 1.0 | 5.18% | `SELECT COUNT(*) FROM "quiz_questions" WHERE ("quiz_questions"."categorisable_ty…` |
| code | app/controllers/quiz/ranks_controller.rb:4 | 7.5 | 1.0 | 3.57% | `Quiz::RanksController#show` |
| view | app/views/quiz/ranks/show.html.erb | 7.2 | 1.0 | 3.42% |  |
| sql | lib/quiz/stats.rb:16 | 6.0 | 1.0 | 2.85% | `SELECT COUNT(*) FROM "quiz_answers" WHERE "quiz_answers"."question_id" IN (?) O…` |
| sql | lib/quiz/stats.rb:21 | 5.7 | 1.0 | 2.71% | `SELECT COUNT(*) FROM "quiz_answers" INNER JOIN "quiz_propositions" ON "quiz_pro…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135493/requests/Quiz::RanksController%23show?range=2026-06-12+11%3A43%3A42+UTC..2026-06-12+16%3A40%3A16+UTC)