# Quiz::RanksController#show

- **Period:** 12 Jun 05:09 UTC – 13 Jun 05:08 UTC
- **Throughput**: 0.01 / min
- **Average:** 207.6 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | lib/quiz/stats.rb:120 | 67.25 | 1.0 | 32.39% | `WITH first_answers AS ( SELECT qa.user_id, qa.question_id, qa.proposition_id, R…` |
| sql | app/views/layouts/quiz_answer.html.erb:87 | 36.83 | 1.0 | 17.74% | `SELECT sub_categories.*, count(quiz_answers.id) as quiz_answers_count FROM "sub…` |
| sql | app/views/layouts/quiz_answer.html.erb:104 | 7.06 | 3.0 | 10.20% | `SELECT topics.*, count(quiz_answers.id) as quiz_answers_count FROM "topics" INN…` |
| sql | app/helpers/forms_helper.rb:80 | 15.5 | 1.0 | 7.47% | `SELECT DISTINCT "groups"."id", "groups"."name", "categories"."name", "categorie…` |
| sql | app/views/layouts/quiz_answer.html.erb:70 | 14.5 | 1.0 | 6.98% | `SELECT categories.*, count(quiz_answers.id) as quiz_answers_count FROM "categor…` |
| sql | lib/quiz/stats.rb:26 | 10.67 | 1.0 | 5.14% | `SELECT COUNT(*) FROM "quiz_questions" WHERE ("quiz_questions"."categorisable_ty…` |
| code | app/controllers/quiz/ranks_controller.rb:4 | 7.33 | 1.0 | 3.53% | `Quiz::RanksController#show` |
| view | app/views/quiz/ranks/show.html.erb | 6.58 | 1.0 | 3.17% |  |
| sql | lib/quiz/stats.rb:16 | 5.33 | 1.0 | 2.57% | `SELECT COUNT(*) FROM "quiz_answers" WHERE "quiz_answers"."question_id" IN (?) O…` |
| sql | lib/quiz/stats.rb:21 | 5.08 | 1.0 | 2.45% | `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=1d)