|
sql
app/jobs/add_shared_satisfactions_job.rb:11
|
73%
|
app/jobs/add_shared_satisfactions_job.rb:11
- Average Self
-
27ms
- Average calls
- 2.1x
- Total Self
- 56ms
- Total Children
- 0ms
- Total runtime
- 56ms
SELECT DISTINCT "company_satisfactions"."id" FROM "company_satisfactions" INNER JOIN "shared_satisfactions" ON "shared_satisfactions"."company_satisfaction_id" = "company_satisfactions"."id" INNER JOIN "experts" ON "experts"."id" = "shared_satisfactions"."expert_id" INNER JOIN "antennes" ON "antennes"."id" = "experts"."antenne_id" WHERE "experts"."antenne_id" IN (?)
SELECT "company_satisfactions"."id" FROM "company_satisfactions" INNER JOIN "shared_satisfactions" ON "company_satisfactions"."id" = "shared_satisfactions"."company_satisfaction_id" WHERE "shared_satisfactions"."user_id" = ?
SELECT DISTINCT "company_satisfactions"."id" FROM "company_satisfactions" INNER JOIN "shared_satisfactions" ON "shared_satisfactions"."company_satisfaction_id" = "company_satisfactions"."id" INNER JOIN "experts" ON "experts"."id" = "shared_satisfactions"."expert_id" INNER JOIN "antennes" ON "antennes"."id" = "experts"."antenne_id" WHERE "experts"."antenne_id" = ?
|
|
code
app/jobs/add_shared_satisfactions_job.rb:4
|
8%
|
app/jobs/add_shared_satisfactions_job.rb:4
- Average Self
-
6.4ms
- Average calls
- 1x
- Total Self
- 6.4ms
- Total Children
- 68ms
- Total runtime
- 75ms
AddSharedSatisfactionsJob#perform
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:8
|
7%
|
app/jobs/add_shared_satisfactions_job.rb:8
- Average Self
-
5.5ms
- Average calls
- 1x
- Total Self
- 5.5ms
- Total Children
- 0ms
- Total runtime
- 5.5ms
SELECT DISTINCT "antennes".* FROM "antennes" INNER JOIN "user_rights" ON "antennes"."id" = "user_rights"."rightable_element_id" INNER JOIN "user_rights" "user_rights_antennes" ON "user_rights_antennes"."rightable_element_type" = ? AND "user_rights_antennes"."rightable_element_id" = "antennes"."id" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? AND "user_rights"."rightable_element_type" = ? ORDER BY "antennes"."id" ASC LIMIT ?
|
|
redis
app/models/antenne.rb:269
|
4%
|
app/models/antenne.rb:269
- Average Self
-
1.7ms
- Average calls
- 1.6x
- Total Self
- 2.7ms
- Total Children
- 0ms
- Total runtime
- 2.7ms
get
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:5
|
2%
|
app/jobs/add_shared_satisfactions_job.rb:5
- Average Self
-
1.6ms
- Average calls
- 1x
- Total Self
- 1.6ms
- Total Children
- 0ms
- Total runtime
- 1.6ms
SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:14
|
1%
|
app/jobs/add_shared_satisfactions_job.rb:14
- Average Self
-
1.4ms
- Average calls
- 0.63x
- Total Self
- 0.85ms
- Total Children
- 0.04ms
- Total runtime
- 0.9ms
SELECT "shared_satisfactions".* FROM "shared_satisfactions" WHERE "shared_satisfactions"."company_satisfaction_id" = ? AND "shared_satisfactions"."user_id" = ? ORDER BY "shared_satisfactions"."id" ASC LIMIT ?
SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?
BEGIN
SELECT ? AS one FROM "shared_satisfactions" WHERE "shared_satisfactions"."user_id" = ? AND "shared_satisfactions"."company_satisfaction_id" = ? AND "shared_satisfactions"."expert_id" = ? LIMIT ?
INSERT INTO "shared_satisfactions" ("user_id", "company_satisfaction_id", "expert_id", "seen_at", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) RETURNING "id"
UPDATE "company_satisfactions" SET "updated_at" = ? WHERE "company_satisfactions"."id" = ?
COMMIT
|
|
code
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13
|
<1%
|
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13
- Average Self
-
0.7ms
- Average calls
- 1x
- Total Self
- 0.7ms
- Total Children
- 75ms
- Total runtime
- 76ms
AddSharedSatisfactionsJob#perform
|
|
cache
app/models/antenne.rb:269
|
<1%
|
app/models/antenne.rb:269
- Average Self
-
0.35ms
- Average calls
- 1.6x
- Total Self
- 0.57ms
- Total Children
- 2.7ms
- Total runtime
- 3.3ms
read
|
|
sql
app/models/antenne.rb:273
|
<1%
|
app/models/antenne.rb:273
- Average Self
-
1.3ms
- Average calls
- 0.18x
- Total Self
- 0.24ms
- Total Children
- 0ms
- Total runtime
- 0.24ms
SELECT "antennes"."id" FROM "antennes" WHERE "antennes"."parent_antenne_id" = ?
|
|
gc
ruby/gc.c
|
<1%
|
ruby/gc.c
- Average Self
-
0.78ms
- Average calls
- 0.27x
- Total Self
- 0.21ms
- Total Children
- 0ms
- Total runtime
- 0.21ms
GC.start
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:13
|
<1%
|
app/jobs/add_shared_satisfactions_job.rb:13
- Average Self
-
1.1ms
- Average calls
- 0.18x
- Total Self
- 0.19ms
- Total Children
- 0ms
- Total runtime
- 0.19ms
SELECT "antennes"."id" FROM "antennes" WHERE "antennes"."id" = ?
SELECT "experts".* FROM "experts" INNER JOIN "matches" ON "experts"."id" = "matches"."expert_id" INNER JOIN "needs" ON "matches"."need_id" = "needs"."id" WHERE "needs"."id" = ? AND "matches"."status" = ? AND "experts"."antenne_id" = ? ORDER BY "experts"."id" ASC LIMIT ?
|
|
code
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182
|
<1%
|
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182
- Average Self
-
0.1ms
- Average calls
- 1x
- Total Self
- 0.1ms
- Total Children
- 76ms
- Total runtime
- 76ms
|
|
sql
app/models/user.rb:344
|
<1%
|
app/models/user.rb:344
- Average Self
-
3ms
- Average calls
- 0.01x
- Total Self
- 0.04ms
- Total Children
- 0ms
- Total runtime
- 0.04ms
SELECT DISTINCT "antennes".* FROM "antennes" INNER JOIN "user_rights" ON "antennes"."id" = "user_rights"."rightable_element_id" INNER JOIN "user_rights" "user_rights_antennes" ON "user_rights_antennes"."rightable_element_type" = ? AND "user_rights_antennes"."rightable_element_id" = "antennes"."id" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? AND "user_rights"."rightable_element_type" = ?
|
|
sql
app/models/user.rb:310
|
<1%
|
app/models/user.rb:310
- Average Self
-
0.5ms
- Average calls
- 0.09x
- Total Self
- 0.04ms
- Total Children
- 0ms
- Total runtime
- 0.04ms
SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?
|
|
code
vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130
|
<1%
|
vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130
- Average Self
-
0.03ms
- Average calls
- 1x
- Total Self
- 0.03ms
- Total Children
- 75ms
- Total runtime
- 75ms
AddSharedSatisfactionsJob
|
|
sql
app/models/antenne.rb:271
|
<1%
|
app/models/antenne.rb:271
- Average Self
-
1ms
- Average calls
- 0.01x
- Total Self
- 0.01ms
- Total Children
- 0ms
- Total runtime
- 0.01ms
SELECT "institutions".* FROM "institutions" WHERE "institutions"."id" = ? LIMIT ?
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:12
|
<1%
|
app/jobs/add_shared_satisfactions_job.rb:12
- Average Self
-
0ms
- Average calls
- 0.01x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "company_satisfactions".* FROM "company_satisfactions" WHERE "company_satisfactions"."id" IN (?) ORDER BY "company_satisfactions"."id" ASC LIMIT ?
|