|
code
app/controllers/quiz/answers_controller.rb:37
|
54%
|
app/controllers/quiz/answers_controller.rb:37
- Average Self
-
211ms
- Average calls
- 1x
- Total Self
- 211ms
- Total Children
- 172ms
- Total runtime
- 383ms
Quiz::AnswersController#new
|
|
sql
app/views/layouts/quiz_answer.html.erb:87
|
9%
|
app/views/layouts/quiz_answer.html.erb:87
- Average Self
-
37ms
- Average calls
- 0.89x
- Total Self
- 33ms
- Total Children
- 0ms
- Total runtime
- 33ms
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
app/helpers/forms_helper.rb:80
|
8%
|
app/helpers/forms_helper.rb:80
- Average Self
-
37ms
- Average calls
- 0.85x
- Total Self
- 32ms
- Total Children
- 0ms
- Total runtime
- 32ms
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
lib/quiz/stats.rb:120
|
6%
|
lib/quiz/stats.rb:120
- Average Self
-
25ms
- Average calls
- 0.89x
- Total Self
- 22ms
- Total Children
- 0ms
- Total runtime
- 22ms
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 (?))
),
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/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.89x
- 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.1ms
- Average calls
- 0.89x
- Total Self
- 6.3ms
- Total Children
- 0ms
- Total runtime
- 6.3ms
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 (?)))
|
|
sql
app/helpers/forms_helper.rb:107
|
1%
|
app/helpers/forms_helper.rb:107
- Average Self
-
21ms
- Average calls
- 0.26x
- Total Self
- 5.4ms
- Total Children
- 0ms
- Total runtime
- 5.4ms
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
-
4.4ms
- Average calls
- 0.89x
- Total Self
- 3.9ms
- Total Children
- 40ms
- Total runtime
- 44ms
|
|
sql
app/controllers/concerns/guest_user.rb:31
|
<1%
|
app/controllers/concerns/guest_user.rb:31
- Average Self
-
1ms
- Average calls
- 3.4x
- Total Self
- 3.4ms
- Total Children
- 0.29ms
- 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
-
4.2ms
- Average calls
- 0.54x
- Total Self
- 2.3ms
- Total Children
- 0ms
- Total runtime
- 2.3ms
GC.start
|
|
sql
lib/quiz/selection.rb:11
|
<1%
|
lib/quiz/selection.rb:11
- Average Self
-
0.73ms
- Average calls
- 2.6x
- Total Self
- 1.9ms
- Total Children
- 0.12ms
- Total runtime
- 2ms
BEGIN
UPDATE "users" SET "updated_at" = ?, "quiz_selected_questions" = ? WHERE "users"."id" = ?
COMMIT
|
|
sql
app/controllers/concerns/guest_user.rb:27
|
<1%
|
app/controllers/concerns/guest_user.rb:27
- Average Self
-
1.8ms
- Average calls
- 1x
- Total Self
- 1.8ms
- Total Children
- 0ms
- Total runtime
- 1.8ms
SELECT "users".* FROM "users" WHERE "users"."email" IS NULL LIMIT ?
|
|
queue
queue
|
<1%
|
queue
- Average Self
-
1.6ms
- Average calls
- 1x
- Total Self
- 1.6ms
- Total Children
- 0ms
- Total runtime
- 1.6ms
|
|
sql
lib/quiz/stats.rb:16
|
<1%
|
lib/quiz/stats.rb:16
- Average Self
-
1.8ms
- Average calls
- 0.89x
- Total Self
- 1.6ms
- Total Children
- 0ms
- Total runtime
- 1.6ms
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/quiz/answers_controller.rb:39
|
<1%
|
app/controllers/quiz/answers_controller.rb:39
- Average Self
-
0.45ms
- Average calls
- 3x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
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.5ms
- Average calls
- 0.86x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
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.81x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
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" = ?
|
|
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
-
1.2ms
- Average calls
- 1x
- Total Self
- 1.2ms
- Total Children
- 384ms
- Total runtime
- 385ms
ActionDispatch::Session::CookieStore
|
|
view
app/views/quiz/questions/_question_subheading.html.erb
|
<1%
|
app/views/quiz/questions/_question_subheading.html.erb
- Average Self
-
0.99ms
- Average calls
- 1x
- Total Self
- 0.99ms
- Total Children
- 0.49ms
- 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.89x
- Total Self
- 0.94ms
- Total Children
- 0ms
- Total runtime
- 0.94ms
|
|
view
app/views/quiz/answers/_stats.html.erb
|
<1%
|
app/views/quiz/answers/_stats.html.erb
- Average Self
-
1ms
- Average calls
- 0.89x
- Total Self
- 0.89ms
- Total Children
- 31ms
- Total runtime
- 32ms
|
|
sql
app/models/concerns/sluggable.rb:34
|
<1%
|
app/models/concerns/sluggable.rb:34
- Average Self
-
0.18ms
- Average calls
- 4.3x
- Total Self
- 0.79ms
- Total Children
- 0ms
- Total runtime
- 0.79ms
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.61ms
- Average calls
- 1x
- Total Self
- 0.61ms
- Total Children
- 383ms
- Total runtime
- 384ms
Warden::Manager
|
|
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.36ms
- Average calls
- 1x
- Total Self
- 0.36ms
- Total Children
- 386ms
- Total runtime
- 386ms
Rails::Rack::Logger
|
|
view
app/views/quiz/answers/_form.html.erb
|
<1%
|
app/views/quiz/answers/_form.html.erb
- Average Self
-
0.33ms
- Average calls
- 1x
- Total Self
- 0.33ms
- Total Children
- 0ms
- Total runtime
- 0.33ms
|
|
sql
app/controllers/quiz/answers_controller.rb:41
|
<1%
|
app/controllers/quiz/answers_controller.rb:41
- Average Self
-
0.32ms
- Average calls
- 1x
- Total Self
- 0.32ms
- Total Children
- 0ms
- Total runtime
- 0.32ms
SELECT COUNT(*) FROM "quiz_answers" WHERE "quiz_answers"."user_id" = ?
|
|
view
app/views/quiz/answers/new.html.erb
|
<1%
|
app/views/quiz/answers/new.html.erb
- Average Self
-
0.31ms
- Average calls
- 1x
- Total Self
- 0.31ms
- Total Children
- 2.2ms
- Total runtime
- 2.5ms
|
|
sql
app/models/topic.rb:166
|
<1%
|
app/models/topic.rb:166
- Average Self
-
0.06ms
- Average calls
- 5.4x
- Total Self
- 0.3ms
- Total Children
- 0ms
- Total runtime
- 0.3ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
lib/quiz/selects.rb:20
|
<1%
|
lib/quiz/selects.rb:20
- Average Self
-
0.34ms
- Average calls
- 0.84x
- Total Self
- 0.28ms
- Total Children
- 0ms
- Total runtime
- 0.28ms
SELECT ? AS one FROM "sub_categories" WHERE "sub_categories"."category_id" = ? LIMIT ?
|
|
sql
lib/quiz/selection.rb:67
|
<1%
|
lib/quiz/selection.rb:67
- Average Self
-
2.3ms
- Average calls
- 0.11x
- Total Self
- 0.26ms
- Total Children
- 0ms
- Total runtime
- 0.26ms
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.19ms
- Average calls
- 1x
- Total Self
- 0.19ms
- Total Children
- 384ms
- Total runtime
- 384ms
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.14ms
- Average calls
- 1x
- Total Self
- 0.14ms
- Total Children
- 386ms
- Total runtime
- 387ms
ActionDispatch::Static
|
|
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.14ms
- Average calls
- 1x
- Total Self
- 0.14ms
- Total Children
- 385ms
- Total runtime
- 386ms
ActionDispatch::Cookies
|
|
view
app/views/quiz/answers/_question.html.erb
|
<1%
|
app/views/quiz/answers/_question.html.erb
- Average Self
-
0.13ms
- Average calls
- 1x
- Total Self
- 0.13ms
- Total Children
- 1.5ms
- Total runtime
- 1.6ms
|
|
sql
lib/quiz/link_to_essays.rb:70
|
<1%
|
lib/quiz/link_to_essays.rb:70
- Average Self
-
0.38ms
- Average calls
- 0.34x
- Total Self
- 0.13ms
- Total Children
- 0ms
- Total runtime
- 0.13ms
SELECT "essays".* FROM "essays" WHERE "essays"."id" = ? LIMIT ?
SELECT "essay_contents_internals".* FROM "essay_contents_internals" WHERE "essay_contents_internals"."id" = ? LIMIT ?
|
|
sql
app/models/sub_category.rb:85
|
<1%
|
app/models/sub_category.rb:85
- Average Self
-
0.24ms
- Average calls
- 0.51x
- Total Self
- 0.12ms
- Total Children
- 0ms
- Total runtime
- 0.12ms
SELECT "groups".* FROM "groups" INNER JOIN "categories" ON "groups"."id" = "categories"."group_id" WHERE "categories"."id" = ? LIMIT ?
|
|
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
- 387ms
- Total runtime
- 387ms
Rails::Engine#call
|
|
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.11ms
- Average calls
- 1x
- Total Self
- 0.11ms
- Total Children
- 386ms
- Total runtime
- 386ms
ActionDispatch::Executor
|
|
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.1ms
- Average calls
- 1x
- Total Self
- 0.1ms
- Total Children
- 384ms
- Total runtime
- 384ms
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.09ms
- Average calls
- 1x
- Total Self
- 0.09ms
- Total Children
- 384ms
- Total runtime
- 384ms
Rack::TempfileReaper
|
|
sql
app/models/sub_category.rb:106
|
<1%
|
app/models/sub_category.rb:106
- Average Self
-
0.06ms
- Average calls
- 1.6x
- Total Self
- 0.09ms
- Total Children
- 0ms
- Total runtime
- 0.09ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/description.rb:86
|
<1%
|
lib/quiz/description.rb:86
- Average Self
-
0.22ms
- Average calls
- 0.41x
- Total Self
- 0.09ms
- Total Children
- 0ms
- Total runtime
- 0.09ms
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
sql
app/models/category.rb:19
|
<1%
|
app/models/category.rb:19
- Average Self
-
0.16ms
- Average calls
- 0.52x
- Total Self
- 0.08ms
- Total Children
- 0ms
- Total runtime
- 0.08ms
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
rack
ActionDispatch::Flash
|
<1%
|
ActionDispatch::Flash
- Average Self
-
0.08ms
- Average calls
- 1x
- Total Self
- 0.08ms
- Total Children
- 384ms
- Total runtime
- 384ms
|
|
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.08ms
- Average calls
- 1x
- Total Self
- 0.08ms
- Total Children
- 384ms
- Total runtime
- 384ms
ActionDispatch::ContentSecurityPolicy::Middleware
|
|
sql
lib/quiz/stats.rb:21
|
<1%
|
lib/quiz/stats.rb:21
- Average Self
-
2.5ms
- Average calls
- 0.03x
- Total Self
- 0.07ms
- Total Children
- 0ms
- Total runtime
- 0.07ms
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/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.07ms
- Average calls
- 1x
- Total Self
- 0.07ms
- Total Children
- 386ms
- Total runtime
- 386ms
ActionDispatch::Callbacks
|
|
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.07ms
- Average calls
- 1x
- Total Self
- 0.07ms
- Total Children
- 386ms
- Total runtime
- 386ms
ActionDispatch::RequestId
|
|
sql
app/models/category.rb:122
|
<1%
|
app/models/category.rb:122
- Average Self
-
0.36ms
- Average calls
- 0.15x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
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.05ms
- Average calls
- 1x
- Total Self
- 0.05ms
- Total Children
- 386ms
- Total runtime
- 386ms
Rack::Rewrite
|
|
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.05ms
- Average calls
- 1x
- Total Self
- 0.05ms
- Total Children
- 386ms
- Total runtime
- 386ms
ActionDispatch::DebugExceptions
|
|
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.04ms
- Average calls
- 1x
- Total Self
- 0.04ms
- Total Children
- 387ms
- Total runtime
- 387ms
Rack::Sendfile
|
|
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.04ms
- Average calls
- 1x
- Total Self
- 0.04ms
- Total Children
- 386ms
- Total runtime
- 386ms
Rack::MethodOverride
|
|
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
- 386ms
- Total runtime
- 386ms
Rack::Runtime
|
|
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.04ms
- Average calls
- 1x
- Total Self
- 0.04ms
- Total Children
- 386ms
- Total runtime
- 386ms
ActionDispatch::RemoteIp
|
|
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.03ms
- Average calls
- 1x
- Total Self
- 0.03ms
- Total Children
- 386ms
- Total runtime
- 386ms
Rails::Rack::SilenceRequest
|
|
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.03ms
- Average calls
- 1x
- Total Self
- 0.03ms
- Total Children
- 384ms
- Total runtime
- 384ms
Rack::Head
|
|
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
- 386ms
- Total runtime
- 386ms
RequestStore::Middleware
|
|
sql
app/models/topic.rb:221
|
<1%
|
app/models/topic.rb:221
- Average Self
-
0.04ms
- Average calls
- 0.68x
- Total Self
- 0.03ms
- Total Children
- 0ms
- Total runtime
- 0.03ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
SELECT "groups".* FROM "groups" WHERE "groups"."id" = ? LIMIT ?
|
|
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.03ms
- Average calls
- 1x
- Total Self
- 0.03ms
- Total Children
- 386ms
- Total runtime
- 386ms
ActionDispatch::ShowExceptions
|
|
sql
lib/quiz/link_to_essays.rb:63
|
<1%
|
lib/quiz/link_to_essays.rb:63
- Average Self
-
0.05ms
- Average calls
- 0.41x
- Total Self
- 0.02ms
- Total Children
- 0ms
- Total runtime
- 0.02ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/title.rb:53
|
<1%
|
lib/quiz/title.rb:53
- Average Self
-
0.03ms
- Average calls
- 0.69x
- 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.03ms
- 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:249
|
<1%
|
app/models/topic.rb:249
- Average Self
-
0.02ms
- Average calls
- 0.69x
- 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/link_to_essays.rb:68
|
<1%
|
lib/quiz/link_to_essays.rb:68
- Average Self
-
0.04ms
- Average calls
- 0.17x
- Total Self
- <0.01ms
- Total Children
- 0ms
- Total runtime
- <0.01ms
SELECT "topics".* FROM "topics" WHERE "topics"."id" = ? LIMIT ?
|
|
sql
app/models/topic.rb:235
|
<1%
|
app/models/topic.rb:235
- Average Self
-
0.02ms
- Average calls
- 0.34x
- 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:105
|
<1%
|
lib/quiz/selects.rb:105
- Average Self
-
0ms
- Average calls
- 0.17x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "topics".* FROM "topics" WHERE "topics"."id" = ? LIMIT ?
|
|
sql
lib/quiz/description.rb:95
|
<1%
|
lib/quiz/description.rb:95
- Average Self
-
0ms
- Average calls
- 0.17x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "categories".* FROM "categories" WHERE "categories"."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:94
|
<1%
|
lib/quiz/selects.rb:94
- Average Self
-
0ms
- Average calls
- 0.34x
- 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/description.rb:85
|
<1%
|
lib/quiz/description.rb:85
- Average Self
-
0ms
- Average calls
- 0.41x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "categories".* FROM "categories" WHERE "categories"."id" = ? LIMIT ?
|
|
sql
lib/quiz/selects.rb:92
|
<1%
|
lib/quiz/selects.rb:92
- Average Self
-
0ms
- Average calls
- 0.81x
- 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/description.rb:93
|
<1%
|
lib/quiz/description.rb:93
- Average Self
-
0ms
- Average calls
- 0.17x
- 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.17x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
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.41x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "sub_categories".* FROM "sub_categories" WHERE "sub_categories"."slug" = ? LIMIT ?
|
|
sql
lib/quiz/description.rb:96
|
<1%
|
lib/quiz/description.rb:96
- Average Self
-
0ms
- Average calls
- 0.17x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
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/selects.rb:51
|
<1%
|
lib/quiz/selects.rb:51
- Average Self
-
0ms
- Average calls
- 0.17x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "sub_categories".* FROM "sub_categories" WHERE "sub_categories"."id" = ? LIMIT ?
|