|
code
app/controllers/quiz/answers_controller.rb:37
|
50%
|
app/controllers/quiz/answers_controller.rb:37
- Average Self
-
189ms
- Average calls
- 1x
- Total Self
- 189ms
- Total Children
- 177ms
- Total runtime
- 367ms
Quiz::AnswersController#new
|
|
sql
app/views/layouts/quiz_answer.html.erb:87
|
9%
|
app/views/layouts/quiz_answer.html.erb:87
- Average Self
-
38ms
- Average calls
- 0.9x
- Total Self
- 34ms
- Total Children
- 0ms
- Total runtime
- 34ms
SELECT sub_categories.*, count(quiz_answers.id) as quiz_answers_count FROM "sub_categories" INNER JOIN "quiz_questions" ON "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" = "sub_categories"."id" INNER JOIN "quiz_answers" ON "quiz_answers"."question_id" = "quiz_questions"."id" GROUP BY "sub_categories"."id" ORDER BY quiz_answers_count DESC LIMIT ?
|
|
sql
lib/quiz/stats.rb:120
|
9%
|
lib/quiz/stats.rb:120
- Average Self
-
36ms
- Average calls
- 0.9x
- Total Self
- 32ms
- Total Children
- 0ms
- Total runtime
- 32ms
WITH first_answers AS (
SELECT
qa.user_id,
qa.question_id,
qa.proposition_id,
ROW_NUMBER() OVER (
PARTITION BY qa.user_id, qa.question_id
ORDER BY qa.id ASC
) AS row_number
FROM quiz_answers qa
WHERE qa.question_id IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?))))
),
points_counts AS (
SELECT
fa.user_id,
COUNT(CASE WHEN qp.correct = true THEN ? ELSE NULL END) AS points_count
FROM first_answers fa
INNER JOIN quiz_propositions qp ON qp.id = fa.proposition_id
WHERE fa.row_number = ?
GROUP BY fa.user_id
)
SELECT
user_id,
points_count,
DENSE_RANK() OVER (ORDER BY points_count DESC) AS rank
FROM points_counts;
|
|
sql
app/helpers/forms_helper.rb:80
|
7%
|
app/helpers/forms_helper.rb:80
- Average Self
-
33ms
- Average calls
- 0.82x
- Total Self
- 27ms
- Total Children
- 0ms
- Total runtime
- 27ms
SELECT DISTINCT "groups"."id", "groups"."name", "categories"."name", "categories"."slug" FROM "categories" INNER JOIN "groups" ON "groups"."id" = "categories"."group_id" LEFT OUTER JOIN "quiz_questions" ON "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" = "categories"."id" LEFT OUTER JOIN "sub_categories" ON "sub_categories"."category_id" = "categories"."id" LEFT OUTER JOIN "quiz_questions" "quiz_questions_sub_categories" ON "quiz_questions_sub_categories"."categorisable_type" = ? AND "quiz_questions_sub_categories"."categorisable_id" = "sub_categories"."id" LEFT OUTER JOIN "topics" ON "topics"."sub_category_id" = "sub_categories"."id" LEFT OUTER JOIN "quiz_questions" "quiz_questions_topics" ON "quiz_questions_topics"."categorisable_type" = ? AND "quiz_questions_topics"."categorisable_id" = "topics"."id" WHERE ("quiz_questions"."id" IS NOT NULL AND "quiz_questions"."status" = ? OR "quiz_questions_sub_categories"."id" IS NOT NULL AND "quiz_questions_sub_categories"."status" = ? OR "quiz_questions_topics"."id" IS NOT NULL AND "quiz_questions_topics"."status" = ?) AND "groups"."name" != ? AND "groups"."subject" = ? AND "groups"."exercice_type" = ? ORDER BY groups.id ASC
|
|
sql
app/views/layouts/quiz_answer.html.erb:104
|
5%
|
app/views/layouts/quiz_answer.html.erb:104
- Average Self
-
7.2ms
- Average calls
- 2.7x
- Total Self
- 19ms
- Total Children
- 0ms
- Total runtime
- 19ms
SELECT topics.*, count(quiz_answers.id) as quiz_answers_count FROM "topics" INNER JOIN "quiz_questions" ON "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" = "topics"."id" INNER JOIN "quiz_answers" ON "quiz_answers"."question_id" = "quiz_questions"."id" GROUP BY "topics"."id" ORDER BY quiz_answers_count DESC LIMIT ?
SELECT "categories".* FROM "categories" WHERE "categories"."id" IN (?)
SELECT "groups".* FROM "groups" WHERE "groups"."id" IN (?)
|
|
sql
app/views/layouts/quiz_answer.html.erb:70
|
4%
|
app/views/layouts/quiz_answer.html.erb:70
- Average Self
-
15ms
- Average calls
- 0.9x
- Total Self
- 14ms
- Total Children
- 0ms
- Total runtime
- 14ms
SELECT categories.*, count(quiz_answers.id) as quiz_answers_count FROM "categories" INNER JOIN "quiz_questions" ON "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" = "categories"."id" INNER JOIN "quiz_answers" ON "quiz_answers"."question_id" = "quiz_questions"."id" GROUP BY "categories"."id" ORDER BY quiz_answers_count DESC LIMIT ?
|
|
sql
app/controllers/quiz/answers_controller.rb:77
|
3%
|
app/controllers/quiz/answers_controller.rb:77
- Average Self
-
10ms
- Average calls
- 1x
- Total Self
- 10ms
- Total Children
- 0ms
- Total runtime
- 10ms
SELECT "quiz_questions"."id" FROM "quiz_questions" WHERE ("quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?))) AND "quiz_questions"."status" = ? AND "quiz_questions"."id" NOT IN (?) ORDER BY RANDOM() LIMIT ?
|
|
sql
lib/quiz/stats.rb:26
|
2%
|
lib/quiz/stats.rb:26
- Average Self
-
7.2ms
- Average calls
- 0.9x
- Total Self
- 6.4ms
- Total Children
- 0ms
- Total runtime
- 6.4ms
SELECT COUNT(*) FROM "quiz_questions" WHERE ("quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)))
|
|
queue
queue
|
1%
|
queue
- Average Self
-
4.4ms
- Average calls
- 1x
- Total Self
- 4.4ms
- Total Children
- 0ms
- Total runtime
- 4.4ms
|
|
sql
app/helpers/forms_helper.rb:107
|
1%
|
app/helpers/forms_helper.rb:107
- Average Self
-
21ms
- Average calls
- 0.19x
- Total Self
- 4.2ms
- Total Children
- 0ms
- Total runtime
- 4.2ms
SELECT DISTINCT "topics".* FROM "topics" LEFT OUTER JOIN "quiz_questions" ON "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" = "topics"."id" WHERE "quiz_questions"."id" IS NOT NULL AND "quiz_questions"."status" = ? AND "topics"."sub_category_id" = ?
|
|
view
app/views/quiz/answers/_selects.html.erb
|
<1%
|
app/views/quiz/answers/_selects.html.erb
- Average Self
-
3.9ms
- Average calls
- 0.9x
- Total Self
- 3.5ms
- Total Children
- 34ms
- Total runtime
- 37ms
|
|
sql
app/controllers/concerns/guest_user.rb:31
|
<1%
|
app/controllers/concerns/guest_user.rb:31
- Average Self
-
1.1ms
- Average calls
- 3x
- Total Self
- 3.3ms
- Total Children
- 0.28ms
- Total runtime
- 3.6ms
BEGIN
SELECT ? AS one FROM "users" WHERE "users"."email" = ? LIMIT ?
INSERT INTO "users" ("email", "encrypted_password", "reset_password_token", "reset_password_sent_at", "remember_created_at", "created_at", "updated_at", "username", "level", "last_name", "first_name", "phone_number", "resume", "stripe_id", "quiz_selected_questions") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING "id"
COMMIT
|
|
gc
ruby/gc.c
|
<1%
|
ruby/gc.c
- Average Self
-
5.2ms
- Average calls
- 0.49x
- Total Self
- 2.5ms
- Total Children
- 0ms
- Total runtime
- 2.5ms
GC.start
|
|
sql
lib/quiz/selection.rb:11
|
<1%
|
lib/quiz/selection.rb:11
- Average Self
-
0.73ms
- Average calls
- 2.4x
- Total Self
- 1.8ms
- Total Children
- 0.11ms
- Total runtime
- 1.9ms
BEGIN
UPDATE "users" SET "updated_at" = ?, "quiz_selected_questions" = ? WHERE "users"."id" = ?
COMMIT
|
|
sql
lib/quiz/stats.rb:16
|
<1%
|
lib/quiz/stats.rb:16
- Average Self
-
2ms
- Average calls
- 0.9x
- Total Self
- 1.8ms
- Total Children
- 0ms
- Total runtime
- 1.8ms
SELECT COUNT(*) FROM "quiz_answers" WHERE "quiz_answers"."question_id" IN (?) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)))) AND "quiz_answers"."id" IN (?) FROM "quiz_answers" WHERE "quiz_answers"."question_id" IN (?) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)))) AND "quiz_answers"."user_id" = ? GROUP BY "quiz_answers"."question_id")
|
|
sql
app/controllers/concerns/guest_user.rb:27
|
<1%
|
app/controllers/concerns/guest_user.rb:27
- Average Self
-
1.5ms
- Average calls
- 1x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
SELECT "users".* FROM "users" WHERE "users"."email" IS NULL LIMIT ?
|
|
sql
app/controllers/quiz/answers_controller.rb:39
|
<1%
|
app/controllers/quiz/answers_controller.rb:39
- Average Self
-
0.5ms
- Average calls
- 3x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
SELECT "quiz_questions".* FROM "quiz_questions" WHERE "quiz_questions"."id" = ? LIMIT ?
SELECT "quiz_propositions".* FROM "quiz_propositions" WHERE "quiz_propositions"."question_id" = ?
SELECT "sub_categories".* FROM "sub_categories" WHERE "sub_categories"."id" = ?
|
|
sql
lib/quiz/selection.rb:65
|
<1%
|
lib/quiz/selection.rb:65
- Average Self
-
1.7ms
- Average calls
- 0.84x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
SELECT ? AS one FROM "quiz_questions" WHERE ("quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?))) LIMIT ?
|
|
sql
app/helpers/forms_helper.rb:94
|
<1%
|
app/helpers/forms_helper.rb:94
- Average Self
-
1.6ms
- Average calls
- 0.69x
- Total Self
- 1.1ms
- Total Children
- 0ms
- Total runtime
- 1.1ms
SELECT DISTINCT "sub_categories".* FROM "sub_categories" LEFT OUTER JOIN "quiz_questions" ON "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" = "sub_categories"."id" LEFT OUTER JOIN "topics" ON "topics"."sub_category_id" = "sub_categories"."id" LEFT OUTER JOIN "quiz_questions" "quiz_questions_topics" ON "quiz_questions_topics"."categorisable_type" = ? AND "quiz_questions_topics"."categorisable_id" = "topics"."id" WHERE ("quiz_questions"."id" IS NOT NULL AND "quiz_questions"."status" = ? OR "quiz_questions_topics"."id" IS NOT NULL AND "quiz_questions_topics"."status" = ?) AND "sub_categories"."category_id" = ?
|
|
view
app/views/quiz/answers/_stats.html.erb
|
<1%
|
app/views/quiz/answers/_stats.html.erb
- Average Self
-
1.1ms
- Average calls
- 0.9x
- Total Self
- 0.99ms
- Total Children
- 41ms
- Total runtime
- 42ms
|
|
view
app/views/quiz/questions/_question_subheading.html.erb
|
<1%
|
app/views/quiz/questions/_question_subheading.html.erb
- Average Self
-
0.98ms
- Average calls
- 1x
- Total Self
- 0.98ms
- Total Children
- 0.55ms
- Total runtime
- 1.5ms
|
|
view
app/views/layouts/application.html.erb
|
<1%
|
app/views/layouts/application.html.erb
- Average Self
-
1.1ms
- Average calls
- 0.9x
- Total Self
- 0.95ms
- Total Children
- 0ms
- Total runtime
- 0.95ms
|
|
sql
app/models/concerns/sluggable.rb:34
|
<1%
|
app/models/concerns/sluggable.rb:34
- Average Self
-
0.18ms
- Average calls
- 4x
- Total Self
- 0.73ms
- Total Children
- 0ms
- Total runtime
- 0.73ms
SELECT "sub_categories".* FROM "sub_categories" WHERE "sub_categories"."slug" = ? LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/warden-1.2.9/lib/warden/manager.rb:30
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/warden-1.2.9/lib/warden/manager.rb:30
- Average Self
-
0.62ms
- Average calls
- 1x
- Total Self
- 0.62ms
- Total Children
- 367ms
- Total runtime
- 367ms
Warden::Manager
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-session-2.1.1/lib/rack/session/abstract/id.rb:267
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-session-2.1.1/lib/rack/session/abstract/id.rb:267
- Average Self
-
0.6ms
- Average calls
- 1x
- Total Self
- 0.6ms
- Total Children
- 368ms
- Total runtime
- 368ms
ActionDispatch::Session::CookieStore
|
|
view
app/views/quiz/answers/_form.html.erb
|
<1%
|
app/views/quiz/answers/_form.html.erb
- Average Self
-
0.4ms
- Average calls
- 1x
- Total Self
- 0.4ms
- Total Children
- 0ms
- Total runtime
- 0.4ms
|
|
sql
app/controllers/quiz/answers_controller.rb:41
|
<1%
|
app/controllers/quiz/answers_controller.rb:41
- Average Self
-
0.39ms
- Average calls
- 1x
- Total Self
- 0.39ms
- Total Children
- 0ms
- Total runtime
- 0.39ms
SELECT COUNT(*) FROM "quiz_answers" WHERE "quiz_answers"."user_id" = ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.2/lib/rails/rack/logger.rb:20
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.2/lib/rails/rack/logger.rb:20
- Average Self
-
0.32ms
- Average calls
- 1x
- Total Self
- 0.32ms
- Total Children
- 369ms
- Total runtime
- 369ms
Rails::Rack::Logger
|
|
sql
lib/quiz/selects.rb:20
|
<1%
|
lib/quiz/selects.rb:20
- Average Self
-
0.41ms
- Average calls
- 0.77x
- Total Self
- 0.32ms
- Total Children
- 0ms
- Total runtime
- 0.32ms
SELECT ? AS one FROM "sub_categories" WHERE "sub_categories"."category_id" = ? LIMIT ?
|
|
view
app/views/quiz/answers/new.html.erb
|
<1%
|
app/views/quiz/answers/new.html.erb
- Average Self
-
0.3ms
- Average calls
- 1x
- Total Self
- 0.3ms
- Total Children
- 2.3ms
- Total runtime
- 2.6ms
|
|
sql
app/models/topic.rb:166
|
<1%
|
app/models/topic.rb:166
- Average Self
-
0.06ms
- Average calls
- 3.9x
- Total Self
- 0.24ms
- Total Children
- 0ms
- Total runtime
- 0.24ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
lib/quiz/selection.rb:67
|
<1%
|
lib/quiz/selection.rb:67
- Average Self
-
2.1ms
- Average calls
- 0.1x
- Total Self
- 0.21ms
- Total Children
- 0ms
- Total runtime
- 0.21ms
SELECT ? AS one FROM "quiz_questions" WHERE ("quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?))) LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/etag.rb:28
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/etag.rb:28
- Average Self
-
0.18ms
- Average calls
- 1x
- Total Self
- 0.18ms
- Total Children
- 367ms
- Total runtime
- 367ms
Rack::ETag
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/static.rb:26
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/static.rb:26
- Average Self
-
0.17ms
- Average calls
- 1x
- Total Self
- 0.17ms
- Total Children
- 369ms
- Total runtime
- 370ms
ActionDispatch::Static
|
|
sql
app/models/sub_category.rb:85
|
<1%
|
app/models/sub_category.rb:85
- Average Self
-
0.3ms
- Average calls
- 0.51x
- Total Self
- 0.15ms
- Total Children
- 0ms
- Total runtime
- 0.15ms
SELECT "groups".* FROM "groups" INNER JOIN "categories" ON "groups"."id" = "categories"."group_id" WHERE "categories"."id" = ? LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/executor.rb:13
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/executor.rb:13
- Average Self
-
0.13ms
- Average calls
- 1x
- Total Self
- 0.13ms
- Total Children
- 369ms
- Total runtime
- 369ms
ActionDispatch::Executor
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/cookies.rb:706
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/cookies.rb:706
- Average Self
-
0.13ms
- Average calls
- 1x
- Total Self
- 0.13ms
- Total Children
- 368ms
- Total runtime
- 368ms
ActionDispatch::Cookies
|
|
code
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.2/lib/rails/engine.rb:532
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.2/lib/rails/engine.rb:532
- Average Self
-
0.12ms
- Average calls
- 1x
- Total Self
- 0.12ms
- Total Children
- 370ms
- Total runtime
- 370ms
Rails::Engine#call
|
|
sql
lib/quiz/link_to_essays.rb:70
|
<1%
|
lib/quiz/link_to_essays.rb:70
- Average Self
-
0.41ms
- Average calls
- 0.28x
- Total Self
- 0.12ms
- Total Children
- 0ms
- Total runtime
- 0.12ms
SELECT "essays".* FROM "essays" WHERE "essays"."id" = ? LIMIT ?
SELECT "essay_contents_internals".* FROM "essay_contents_internals" WHERE "essay_contents_internals"."id" = ? LIMIT ?
|
|
view
app/views/quiz/answers/_question.html.erb
|
<1%
|
app/views/quiz/answers/_question.html.erb
- Average Self
-
0.11ms
- Average calls
- 1x
- Total Self
- 0.11ms
- Total Children
- 1.5ms
- Total runtime
- 1.6ms
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/conditional_get.rb:28
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/conditional_get.rb:28
- Average Self
-
0.09ms
- Average calls
- 1x
- Total Self
- 0.09ms
- Total Children
- 367ms
- Total runtime
- 368ms
Rack::ConditionalGet
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/tempfile_reaper.rb:16
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/tempfile_reaper.rb:16
- Average Self
-
0.08ms
- Average calls
- 1x
- Total Self
- 0.08ms
- Total Children
- 367ms
- Total runtime
- 367ms
Rack::TempfileReaper
|
|
rack
ActionDispatch::Flash
|
<1%
|
ActionDispatch::Flash
- Average Self
-
0.08ms
- Average calls
- 1x
- Total Self
- 0.08ms
- Total Children
- 368ms
- Total runtime
- 368ms
|
|
sql
app/models/sub_category.rb:106
|
<1%
|
app/models/sub_category.rb:106
- Average Self
-
0.05ms
- Average calls
- 1.5x
- Total Self
- 0.08ms
- Total Children
- 0ms
- Total runtime
- 0.08ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/description.rb:86
|
<1%
|
lib/quiz/description.rb:86
- Average Self
-
0.2ms
- Average calls
- 0.36x
- Total Self
- 0.07ms
- Total Children
- 0ms
- Total runtime
- 0.07ms
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
app/models/category.rb:19
|
<1%
|
app/models/category.rb:19
- Average Self
-
0.13ms
- Average calls
- 0.52x
- Total Self
- 0.07ms
- Total Children
- 0ms
- Total runtime
- 0.07ms
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
app/models/category.rb:122
|
<1%
|
app/models/category.rb:122
- Average Self
-
0.31ms
- Average calls
- 0.22x
- Total Self
- 0.07ms
- Total Children
- 0ms
- Total runtime
- 0.07ms
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-rewrite-1.5.1/lib/rack/rewrite.rb:18
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-rewrite-1.5.1/lib/rack/rewrite.rb:18
- Average Self
-
0.06ms
- Average calls
- 1x
- Total Self
- 0.06ms
- Total Children
- 369ms
- Total runtime
- 369ms
Rack::Rewrite
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/remote_ip.rb:95
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/remote_ip.rb:95
- Average Self
-
0.06ms
- Average calls
- 1x
- Total Self
- 0.06ms
- Total Children
- 369ms
- Total runtime
- 369ms
ActionDispatch::RemoteIp
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/head.rb:14
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/head.rb:14
- Average Self
-
0.06ms
- Average calls
- 1x
- Total Self
- 0.06ms
- Total Children
- 368ms
- Total runtime
- 368ms
Rack::Head
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/request_id.rb:31
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/request_id.rb:31
- Average Self
-
0.06ms
- Average calls
- 1x
- Total Self
- 0.06ms
- Total Children
- 369ms
- Total runtime
- 369ms
ActionDispatch::RequestId
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/callbacks.rb:28
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/callbacks.rb:28
- Average Self
-
0.05ms
- Average calls
- 1x
- Total Self
- 0.05ms
- Total Children
- 368ms
- Total runtime
- 369ms
ActionDispatch::Callbacks
|
|
sql
app/models/topic.rb:221
|
<1%
|
app/models/topic.rb:221
- Average Self
-
0.1ms
- Average calls
- 0.56x
- Total Self
- 0.05ms
- Total Children
- 0ms
- Total runtime
- 0.05ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
lib/quiz/stats.rb:21
|
<1%
|
lib/quiz/stats.rb:21
- Average Self
-
2.7ms
- Average calls
- 0.02x
- Total Self
- 0.05ms
- Total Children
- 0ms
- Total runtime
- 0.05ms
SELECT COUNT(*) FROM "quiz_answers" INNER JOIN "quiz_propositions" ON "quiz_propositions"."id" = "quiz_answers"."proposition_id" WHERE "quiz_answers"."question_id" IN (?) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)))) AND "quiz_answers"."id" IN (?) FROM "quiz_answers" WHERE "quiz_answers"."question_id" IN (?) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)) OR "quiz_questions"."categorisable_type" = ? AND "quiz_questions"."categorisable_id" IN (?)))) AND "quiz_answers"."user_id" = ? GROUP BY "quiz_answers"."question_id") AND "quiz_propositions"."correct" = ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/http/content_security_policy.rb:37
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/http/content_security_policy.rb:37
- Average Self
-
0.05ms
- Average calls
- 1x
- Total Self
- 0.05ms
- Total Children
- 368ms
- Total runtime
- 368ms
ActionDispatch::ContentSecurityPolicy::Middleware
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/sendfile.rb:130
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/sendfile.rb:130
- Average Self
-
0.05ms
- Average calls
- 1x
- Total Self
- 0.05ms
- Total Children
- 370ms
- Total runtime
- 370ms
Rack::Sendfile
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/show_exceptions.rb:31
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/show_exceptions.rb:31
- Average Self
-
0.05ms
- Average calls
- 1x
- Total Self
- 0.05ms
- Total Children
- 369ms
- Total runtime
- 369ms
ActionDispatch::ShowExceptions
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.2/lib/rails/rack/silence_request.rb:27
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.2/lib/rails/rack/silence_request.rb:27
- Average Self
-
0.04ms
- Average calls
- 1x
- Total Self
- 0.04ms
- Total Children
- 369ms
- Total runtime
- 369ms
Rails::Rack::SilenceRequest
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/runtime.rb:22
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/runtime.rb:22
- Average Self
-
0.04ms
- Average calls
- 1x
- Total Self
- 0.04ms
- Total Children
- 369ms
- Total runtime
- 369ms
Rack::Runtime
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/debug_exceptions.rb:30
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.2/lib/action_dispatch/middleware/debug_exceptions.rb:30
- Average Self
-
0.04ms
- Average calls
- 1x
- Total Self
- 0.04ms
- Total Children
- 369ms
- Total runtime
- 369ms
ActionDispatch::DebugExceptions
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/request_store-1.7.0/lib/request_store/middleware.rb:16
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/request_store-1.7.0/lib/request_store/middleware.rb:16
- Average Self
-
0.03ms
- Average calls
- 1x
- Total Self
- 0.03ms
- Total Children
- 369ms
- Total runtime
- 369ms
RequestStore::Middleware
|
|
sql
lib/quiz/link_to_essays.rb:63
|
<1%
|
lib/quiz/link_to_essays.rb:63
- Average Self
-
0.06ms
- Average calls
- 0.36x
- Total Self
- 0.02ms
- Total Children
- 0ms
- Total runtime
- 0.02ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
|
|
sql
app/models/topic.rb:249
|
<1%
|
app/models/topic.rb:249
- Average Self
-
0.04ms
- Average calls
- 0.57x
- Total Self
- 0.02ms
- Total Children
- 0ms
- Total runtime
- 0.02ms
SELECT "sub_categories".* FROM "sub_categories" WHERE "sub_categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/title.rb:53
|
<1%
|
lib/quiz/title.rb:53
- Average Self
-
0.03ms
- Average calls
- 0.57x
- Total Self
- 0.02ms
- Total Children
- 0ms
- Total runtime
- 0.02ms
SELECT "topics".* FROM "topics" WHERE "topics"."id" = ? LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/method_override.rb:19
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.4/lib/rack/method_override.rb:19
- Average Self
-
0.02ms
- Average calls
- 1x
- Total Self
- 0.02ms
- Total Children
- 369ms
- Total runtime
- 369ms
Rack::MethodOverride
|
|
sql
lib/quiz/link_to_essays.rb:68
|
<1%
|
lib/quiz/link_to_essays.rb:68
- Average Self
-
0.12ms
- Average calls
- 0.14x
- Total Self
- 0.02ms
- Total Children
- 0ms
- Total runtime
- 0.02ms
SELECT "topics".* FROM "topics" WHERE "topics"."id" = ? LIMIT ?
|
|
sql
app/models/sub_category.rb:92
|
<1%
|
app/models/sub_category.rb:92
- Average Self
-
0.02ms
- Average calls
- 0.51x
- Total Self
- 0.01ms
- Total Children
- 0ms
- Total runtime
- 0.01ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
|
|
sql
app/models/topic.rb:235
|
<1%
|
app/models/topic.rb:235
- Average Self
-
0.02ms
- Average calls
- 0.28x
- Total Self
- <0.01ms
- Total Children
- 0ms
- Total runtime
- <0.01ms
SELECT "sub_categories".* FROM "sub_categories" WHERE "sub_categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/selects.rb:103
|
<1%
|
lib/quiz/selects.rb:103
- Average Self
-
0ms
- Average calls
- 0.36x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "sub_categories".* FROM "sub_categories" WHERE "sub_categories"."slug" = ? LIMIT ?
|
|
sql
lib/quiz/selects.rb:94
|
<1%
|
lib/quiz/selects.rb:94
- Average Self
-
0ms
- Average calls
- 0.28x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
lib/quiz/selects.rb:92
|
<1%
|
lib/quiz/selects.rb:92
- Average Self
-
0ms
- Average calls
- 0.73x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
lib/quiz/selects.rb:90
|
<1%
|
lib/quiz/selects.rb:90
- Average Self
-
0ms
- Average calls
- 0.26x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
lib/quiz/description.rb:85
|
<1%
|
lib/quiz/description.rb:85
- Average Self
-
0ms
- Average calls
- 0.36x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/selects.rb:51
|
<1%
|
lib/quiz/selects.rb:51
- Average Self
-
0ms
- Average calls
- 0.14x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "sub_categories".* FROM "sub_categories" WHERE "sub_categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/description.rb:93
|
<1%
|
lib/quiz/description.rb:93
- Average Self
-
0ms
- Average calls
- 0.14x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "topics".* FROM "topics" WHERE "topics"."id" = ? LIMIT ?
|
|
sql
lib/quiz/description.rb:94
|
<1%
|
lib/quiz/description.rb:94
- Average Self
-
0ms
- Average calls
- 0.14x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "sub_categories".* FROM "sub_categories" WHERE "sub_categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/description.rb:95
|
<1%
|
lib/quiz/description.rb:95
- Average Self
-
0ms
- Average calls
- 0.14x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/description.rb:96
|
<1%
|
lib/quiz/description.rb:96
- Average Self
-
0ms
- Average calls
- 0.14x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
lib/quiz/selects.rb:101
|
<1%
|
lib/quiz/selects.rb:101
- Average Self
-
0ms
- Average calls
- 0.26x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "categories".* FROM "categories" WHERE "categories"."slug" = ? LIMIT ?
|
|
sql
lib/quiz/selects.rb:105
|
<1%
|
lib/quiz/selects.rb:105
- Average Self
-
0ms
- Average calls
- 0.14x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "topics".* FROM "topics" WHERE "topics"."id" = ? LIMIT ?
|