# Quiz::AnswersController#index

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

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | lib/quiz/stats.rb:120 | 79.95 | 0.92 | 34.28% | `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.95 | 0.92 | 16.27% | `SELECT sub_categories.*, count(quiz_answers.id) as quiz_answers_count FROM "sub…` |
| sql | app/views/layouts/quiz_answer.html.erb:104 | 7.15 | 2.75 | 9.20% | `SELECT topics.*, count(quiz_answers.id) as quiz_answers_count FROM "topics" INN…` |
| code | app/controllers/quiz/answers_controller.rb:4 | 19.08 | 1.0 | 8.93% | `Quiz::AnswersController#index` |
| sql | app/views/layouts/quiz_answer.html.erb:70 | 15.32 | 0.92 | 6.57% | `SELECT categories.*, count(quiz_answers.id) as quiz_answers_count FROM "categor…` |
| sql | app/helpers/forms_helper.rb:80 | 13.37 | 0.79 | 4.95% | `SELECT DISTINCT "groups"."id", "groups"."name", "categories"."name", "categorie…` |
| sql | lib/quiz/stats.rb:26 | 8.91 | 0.92 | 3.82% | `SELECT COUNT(*) FROM "quiz_questions" WHERE ("quiz_questions"."categorisable_ty…` |
| sql | app/views/quiz/answers/index.html.erb:38 | 1.72 | 1.96 | 1.58% | `SELECT "quiz_answers".* FROM "quiz_answers" WHERE "quiz_answers"."question_id" …` |
| sql | lib/quiz/stats.rb:21 | 3.57 | 0.88 | 1.46% | `SELECT COUNT(*) FROM "quiz_answers" INNER JOIN "quiz_propositions" ON "quiz_pro…` |
| sql | app/controllers/quiz/answers_controller.rb:8 | 3.0 | 1.0 | 1.40% | `SELECT COUNT(*) FROM "quiz_answers" WHERE "quiz_answers"."question_id" IN (?) O…` |
| sql | app/views/quiz/answers/index.html.erb:34 | 2.79 | 1.0 | 1.31% | `SELECT COUNT(*) FROM (SELECT ? AS one FROM "quiz_answers" WHERE "quiz_answers".…` |
| queue | queue | 2.71 | 1.0 | 1.27% |  |
| view | app/views/quiz/answers/index.html.erb | 2.33 | 1.0 | 1.09% |  |
| view | app/views/quiz/answers/_stats.html.erb | 2.36 | 0.92 | 1.01% |  |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135493/requests/Quiz::AnswersController%23index?range=1d)